Hi Martin,

Obviously, once you pass midnight, both the NOW() and TODAY() functions
refer to a new day. So NOW() resets to 0 and TODAY() increments by one.
Thus, your test can never return a time value greater than 23:59:59.

Cheers


"Trying to excel in life but need help"
oft.com wrote in message
...
Hello,

Thanks for all the assistance so far. You have all been very helpful and
it
is greatly appreciated.

I am trying to have a cell return a "" value when the clock reached a
certain time.
I have the formula working but it does not work past midnight.

$B$8 formula is: NOW()
=IF($B$8=TODAY()+$B11,"",'M-F'!L9)

This works only up to 23:59 and then returns the value in 'M-F'!L9. I want
to return the "" value.

Can anyone help?

Thanks
Martin