Time Duration Issue

[KuraiChikara]

I have a time duration issue once PM runs into AM.
I will give an example of a working process (AM to PM) and one that doesn't work (PM to AM)

Working Example:
A1: Has 11:50
B1: Has 12:00
C1 Formula: =B1-A1 (this will equal 00:10 or 10 mins has gone by)


Non-Working:
A1: Has 23:50
B1: Has 00:00
C1 Formula:???????

I've tried =B1-A1 and all I get are the never ending pound symbols #######, I've also tried =A1-B1 and that gives me 23:50 which is wrong.

The result is simple, the duration from 23:50 to 00:00 is 10 mins, but I don't know how to show that.

 

[DRSteele]

The sensible policy is to alwasy use the full Excel DateTime serial number. So when the formatting is removed, May 12, 2019 in A1 is [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]43597.9930555556 and B1 is [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]43598, for a difference of [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]0.00694444444525288. Multiply that by 24 and by 60 and that is ten minutes. Using the entire DateTime serial number means you won't have this tick-over problem.[/FONT][/FONT][/FONT][TABLE="width: 149"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[KuraiChikara]

Thank you but I did find a different route. I used the MOD function:
A1: 23:50
B1: 0:00
C1: =MOD((B1-A1),1)

This gives me my result of 0:10