Subtracting Time from NOW() Value
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
|