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

[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

 

[Chua]

You can try the formula...

=IF(D11<=D12,"OK","LATE")

Cheers
Chua

 

[Rick Rothstein \(MVP - VB\)]

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