The reason Matt's formula fails is because NOW() at the moment is 38545
point something or other which of course is bigger than any time which will
be less than one. To make your formula work try using MOD(NOW(),1)*24 in
place of HOUR
--
HTH


Sandy

Replace@mailinator with @tiscali.co.uk
"ynissel" wrote in message
...
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