Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) | |||
Subtracting time | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |