Times formula - do they straddle midnight?

[MOB]

I have 2 times in a spreadsheet - I need a formula to determine whether the start time and end time range include midnight eg;

21:00 03:00 Yes
08:00 20:00 No

I cant get my head round this, can anyone help?

TIA

 

[6StringJazzer]

If these are times only and do not include dates then:

=IF(A1>B1,"Yes","No")

This assumes that the total time span is less than 24 hours. If you have a time span that crosses midnight but it's more than 24 hours, there is no way to tell. For example, in your second example, it is not possible to tell if the times are in the same day (16 hours) or the next day (30 hours).

 

[MOB]

Thanks, I missed the obvious solution!