How to calculate time interval in Excel?

Question

excel

The cell contains time data in this format, for example:

7:00:00-8:30:00;
17:00:00-19:00:00

Or it could just be like this:

18:30:00-19:00:00

These are time periods.

Those. in the first case it should be 1:30:00 + 2:00:00 = 3:30:00 in total, and in the second it should be 0:30:00 .
How to teach excel to count this?

Answer 1

Figured it out myself using vba.

Answer 2

You don't have to create difficulties for yourself. You do not need to enter 7:00:00-8:30:00 in the cell.
Enter 7:00:00 in one cell and 8:30:00 in the other. Yes, it is possible to divide the glued into parts with a formula, but why, if it is easier not to glue.