Hi All

OK thanks for your help and expertise on this.

I'm using this formula to say 'Open' between 8 am and 4.30 pm , and
'Closed' after this.

=IF(AND(MOD(NOW(),1)=TIME(8,0,0),MOD(NOW(),1)<=TI ME(16,30,0)),"Open","Closed")


It works fine. As a refinement , is it possible to modify the formula to
only pertain to weekdays , and say 'Closed' at weekends?

Grateful for any advice.



Best Wishes




In article
,
Pete_UK writes
Try this:

=IF(AND(mod(NOW(),1)=TIME(8,0,0),MOD(NOW(),1)<=T IME
(16,30,0)),"Open","Closed")

Hope this helps.

Pete

On Jan 11, 10:29*pm, Colin Hayes wrote:
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.