ExcelBanter - How to set the time as condition within if statement?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to set the time as condition within if statement? (https://www.excelbanter.com/excel-worksheet-functions/118181-how-set-time-condition-within-if-statement.html)

Eric

How to set the time as condition within if statement?

Does anyone know how to set the time as condition within if statement?
If(current time today's 5pm [after 5pm] and
current time<today's 11:59 pm [before 11:59pm],true,false)

Thank you for any suggestion
Eric

Allllen

How to set the time as condition within if statement?

=IF(AND(NOW()TODAY()+17/24,NOW()<TODAY()+23/24+59/60/24),"true","false")
--
Allllen

"Eric" wrote:

Does anyone know how to set the time as condition within if statement?
If(current time today's 5pm [after 5pm] and
current time<today's 11:59 pm [before 11:59pm],true,false)

Thank you for any suggestion
Eric

Eric

How to set the time as condition within if statement?

Thank you very much
Eric

All times are GMT +1. The time now is 04:06 AM.