LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Trying to excel in life but need help
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Subtracting Time Formula-Horse Racing SMDIYDLI Excel Discussion (Misc queries) 1 December 13th 04 09:27 PM
Subtracting time Pantryman Excel Worksheet Functions 6 November 24th 04 08:53 PM
Subtracting time in date format Collcat Excel Worksheet Functions 1 November 10th 04 09:40 PM
Subtracting time in date format Collcat Excel Worksheet Functions 1 November 10th 04 08:42 PM
Subtracting time in date format Collcat Excel Worksheet Functions 1 November 10th 04 04:45 PM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"