Try this:

=IF(AND(mod(NOW(),1)=TIME(8,0,0),MOD(NOW(),1)<=TI ME
(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.