2 "if formulas", don't know how to use them

[Florin32]

hello all,

I have a problem with 2 "IF formulas"

A B C
23:30 00:30 1:00 - =IF(B2>B2,A2-A2,B2+1-A2)
14:00 13:00 On Time -=IF(B3<A3,"On Time","Delayed")

My question is: - how to make the first line to show me Delayed. It is a problem with the time before and after midnight.

Any sugestion is welcome.

Thank You

[CRIMEDOG]

not sure what you are looking for - But B2>B2 will ALWAYS be false (because B2=B2)
maybe attach a small example -with the result you would like to get

[martindwilson]

=IF(B2>B2,A2-A2,B2+1-A2)
are you sur eabout that formula? b2 can never be >than b2

[Florin32]

yes, i'm sure about that formula B2>B2, it shows me that i have a delayed time of one hour, but i want to show me " Delayed"

[martindwilson]

A cell calue canot be greater or less than itself

[satabp]

May it is B2>A2...

Because I dont see any use of B2>B2, if in that case you can simply use the false action as a formula into the cell..... because True action never ever used...