ExcelBanter - Need a formula: If TIME is or

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need a formula: If TIME is or < than a cell enter TEXT (https://www.excelbanter.com/excel-programming/415365-need-formula-if-time-than-cell-enter-text.html)

cyndinmarianne

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

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

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

You can try the formula...

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

Cheers
Chua

"cyndinmarianne" wrote:

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

Rick Rothstein \(MVP - VB\)[_2517_]

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

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

"cyndinmarianne" wrote in message
...
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

All times are GMT +1. The time now is 11:03 PM.