Thread: On time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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