Taking Military Time and converting it to hours worked

[Tonia_Dykes]

I am currently working on a scheduled hours report. I have gone through many of the military conversion options via the community however I am still struggling. Looking for some assistance on how to convert the below 14:00-00:00 into hours scheduled to work. All of these are exceptions that I cannot seem to get right. I am not sure what I am doing wrong.

   
1 14:00-00:00
2 12:00-08:30
3 18:00-02:30
4 19:00-03:00
5 23:00-03:00
6 23:00-06:00
7 06:00-10:00
8 07:00-15:30
9 06:00-00:00
10 07:00-01:00
11 13:30-00:30
12 13:30-10:00
13 16:00-00:30
14 18:00-00:00
15 18:30-03:00
16 20:00-00:00
17 23:00-05:00
18 23:00-07:30
19 08:00-02:30
20 19:00-03:30
21 17:00-01:30
22 23:00-06:30
23 14:00-00:30
24 15:30-12:00
25 22:00-06:30
26 22:00-05:30
27 21:00-06:00
28 22:00-03:00
29 21:00-05:30
30 15:30-00:00
31 05:30-01:45
32 22:00-04:30
33 23:00-07:00
34 22:00-04:00
35 22:30-07:00
36 21:30-06:00
37 23:00-04:00
38 08:00-00:00
39 06:00-04:30
40 23:00-05:30
41 23:30-17:30
42 22:00-02:00
43 06:30-03:00
44 13:30-12:00
45 16:00-00:00
46 22:00-16:00

[grazitti_sapna · Accepted solution]

@Tonia_Dykes  Can you provide the output you need for some data.

[Tonia_Dykes]

I have attached the report I am working with. I have to take each days shift and create a column of hours to be worked. As I stated all the time conversions seem to be working but every week I get more exceptions like the ones listed above. I am aware that some schedules may be entered wrong but regardless my final solution is to come up with hours-minutes scheduled for each shift/day.