Thread: Using time functions to give a warning
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Using time functions to give a warning
Hi,

Try this

=if(and(time(8,0,0)<=now(),time(16,30,0)=now())," Open","Closed").

This will not auto update. You will have to press F9 to update

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Colin Hayes" wrote in message
...

Hi

In cell I14 I need to put a formula which says 'Open' when the PC clock is
between 8 am and 4.30 pm , and 'Closed' when the PC clock is later than
4.30 pm.

Can someone help with the code , please?

thanks.

Reply With QuoteReply With Quote