How to set the time as condition within if statement?

Eric · Nov 9, 2006

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 · Nov 9, 2006

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

Eric · Nov 10, 2006

Thank you very much
Eric

How to set the time as condition within if statement?

Eric

Allllen

Eric