On time

J

Jeff

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
 
G

Gary''s Student

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

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