Need a formula: If TIME is > or < than a cell enter TEXT

  • Thread starter Thread starter cyndinmarianne
  • Start date Start date
C

cyndinmarianne

Here is my dilemma:
I need a formula to write: If D5 (this will be a time such as 11:00 pm) is <
or = to 11:00 pm enter OK. If D5 is > than 11:00 pm enter LATE

I have searched and tried different formulas, nothing seems to be helping.

Any help is appreciated
 
11:00 PM until when is considered LATE (that is, at what time during the day
is the break point time between LATE and OK)?

Rick
 
Back
Top