Based on the sample you proved (post #11)...
A
B
C
D
E
F
1
 # A B C D E
2
 1 07:00-11:00 07:00-11:00 01:00-23:00 09:00-13:00 07:00-13:00
3
 2 06:00-14:30 06:30-14:30 06:30-14:30 sick 06:30-14:30
4
 3 06:30-15:00 06:30-14:30 06:30-14:30 06:30-14:30 06:30-14:30
5
 Format
6
 General---->
0.875
0.833333333
1.583333333
#VALUE!
0.916666667
7
 Time 37:30:55---->
21:00:00
20:00:00
38:00:00
#VALUE!
22:00:00
8
 =SUMPRODUCT( RIGHT(B2:B4,5)- LEFT(B2:B4,5))


Im still working on when you have "sick" etc