TIME Calculation

[Dough92]

I am trying to get a formula that will tell me in an IF statement if one time is greater than the other with a return of "Success" or "Fail"
works fine with 24 hours, except when it goes past midnight because the first time is earlier (and therefore a smaller number)
example.
A6 = 01:00 (deadline)
B6 = 23:00 (start time)
C6 =IF(A6>B6,"SUCCESS","FAIL") results in a "FAIL", but I want it to say "Success" as it finished 2 hours before the deadline.

[Jonmo1]

I think you'll be best served by including DATEs with your deadlines and start times.

otherwise, it can get very ambiguos and challenging.

Say
A6 = 11:00 (deadline)
B6 = 02:00 (start time)

How can we know (or more precisely, how can Excel know) that B6 is not 2AM the next day, and therefor AFTER 11 AM ?

[Jdevil]

Well, is there a way Excel could know that it is a later day? I myself could not tell if it is a success or a fail is you just give me "01:00" and "23:00" as information