On time
 

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

On time
 

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

=IF(E124<=0.708333333333333,"ONTIME","LATE")
--
Gary's Student


"Jeff" wrote:

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

On time
 

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

"Jeff" wrote:

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