View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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