OK - mine didnt work. but Im having an issue with yours as well
I typed in =IF(NOW()TIME(17,29,0),TRUE,FALSE) but its saying true and its
only 4:26 PM ??
Am I missing something ?
Thanks

"Matt Lunn" wrote:

Hi,

Try this

=IF(NOW()TIME(17,30,0),TRUE,FALSE)

This checks against your current defined system time. It will not keep
checking by itself. To update you can press the F9 key.

Hope this helps,

Matt


"ynissel" wrote:

How do I write an if statement to check if its past 5:30 PM. I tried
if(hour17.5) but that only checks the hr itself and not minutes.
Thanks,
Yosef