Hi Colin
Not sure if that's what you want but try it.
=IF(AND(NOW()TIME(8,0,0),NOW()<TIME(16,30,0)),"Op en","Close")
Make sure your cells are formatted as time.
Regards
John
"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.