Calculation of breaks between workshifts

[brass312]

Guys please help as I ran out of ideas:

I need to calculate workers' rest time between two shifts, example


Day 1 Time in: 8:00
Day 1 Time out: 23:00

Day 2 Time in: 8:00
Day 2 Time out: 17:00

Rest between shifts: 9hrs [so formula would be Day 1 Time out - Day 2 Time in, but it never returns the correct digit]

 

[Special-K99]

Your formula is incorrect, it's (Day2 Time In - Day1 Time Out)

Ensure the date AND time are in the same cell, then just perform the subtraction as above.
Reformat the cell to to hh:mm

 

[brass312]

Your formula is incorrect, it's (Day2 Time In - Day1 Time Out)

Ensure the date AND time are in the same cell, then just perform the subtraction as above.
Reformat the cell to to hh:mm

Yep, but even with hh:mm the formula doesn't calculate it correctly, here the result should be 9 hours not 15 hours

Day 1 Time Out: 23:00
Day 2 Time In: 08:00