On time

[Guest]

I'm trying to get the time in a call, and return if this time is ONTIME or LATE

The time cell is in" 23:00" cell looks 4:47
This is what I was working on, but I cannot remove the ":" without error to
the funtion.

=IF(E124<=5:00,"ONTIME","LATE")

ANy help would be thankful

 

[Guest]

If E124 contains a time and you want late to mean after 5:00 PM then use:

=IF(E124<=0.708333333333333,"ONTIME","LATE")

 

[Guest]

=IF(E124<=TIME(17,0,0),"ON TIME","LATE")