Thread: How to set the time as condition within if statement?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
  
Posts: 341
Default 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

Reply With QuoteReply With Quote