All Tricks and formula failed when you wanted to do time difference for midnight .. mostly questions arise like
“How do I calculate the time duration in minutes between two times when the first time is before midnight and the second time is after midnight?
And solution is :
B2 cell contain value : 23:00
C2 cell contain value : 1:37
Formula is D2: =C2-B2+(B2>C2)
Why it works, time is a fraction of a day, the comparison B2>C2
returns True (1) or False (0), if true 1 day (24 hours) is added.