Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Day/Time Countdown
How can I set up a formula in Excel to countdown from NOW to a certain date
and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
#2
|
|||
|
|||
=NOW()-A1
Where 10/7/2005 is in A1. ************ Anne Troy www.OfficeArticles.com "SeekingHelp" wrote in message ... How can I set up a formula in Excel to countdown from NOW to a certain date and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
#3
|
|||
|
|||
"Anne Troy" wrote in message
... =NOW()-A1 That will return a negative number, I assume that you mean =A1-NOW() -- Regards Sandy Replace@mailinator with @tiscali.co.uk "Anne Troy" wrote in message ... =NOW()-A1 Where 10/7/2005 is in A1. ************ Anne Troy www.OfficeArticles.com "SeekingHelp" wrote in message ... How can I set up a formula in Excel to countdown from NOW to a certain date and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
#4
|
|||
|
|||
Actually, no. I meant it the way I said it. After all, NASA says "T minus
whatever". But, of course, either works just fine. :) ************ Anne Troy www.OfficeArticles.com "Sandy Mann" wrote in message ... "Anne Troy" wrote in message ... =NOW()-A1 That will return a negative number, I assume that you mean =A1-NOW() -- Regards Sandy Replace@mailinator with @tiscali.co.uk "Anne Troy" wrote in message ... =NOW()-A1 Where 10/7/2005 is in A1. ************ Anne Troy www.OfficeArticles.com "SeekingHelp" wrote in message ... How can I set up a formula in Excel to countdown from NOW to a certain date and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
#5
|
|||
|
|||
I also found this... could be overkill for you.
http://www.tushar-mehta.com/excel/software/countdown/ ************ Anne Troy www.OfficeArticles.com "SeekingHelp" wrote in message ... How can I set up a formula in Excel to countdown from NOW to a certain date and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
#7
|
|||
|
|||
Duh. I never even looked, Sandy. I got negative nine days and something, and
never did the format when I tested the formula. Of course I know you can't do negative in time in Excel (unless you're one of those two Mac users). Would you believe I taught Advanced Excel to the US EPA. HEY!! I hear you laughing!! CUT THAT OUT!! LOL!! ************ Anne Troy www.OfficeArticles.com "Sandy Mann" wrote in message ... NASA may be able to work with negative time but Excel can't unless the 1904 date syetm is selected which will change the date in A1 from 10/7/05 to 10/8/09 - but then you knew that <g -- Regards Sandy Replace@mailinator with @tiscali.co.uk "Anne Troy" wrote in message ... Actually, no. I meant it the way I said it. After all, NASA says "T minus whatever". But, of course, either works just fine. :) ************ Anne Troy www.OfficeArticles.com "Sandy Mann" wrote in message ... "Anne Troy" wrote in message ... =NOW()-A1 That will return a negative number, I assume that you mean =A1-NOW() -- Regards Sandy Replace@mailinator with @tiscali.co.uk "Anne Troy" wrote in message ... =NOW()-A1 Where 10/7/2005 is in A1. ************ Anne Troy www.OfficeArticles.com "SeekingHelp" wrote in message ... How can I set up a formula in Excel to countdown from NOW to a certain date and time. i.e. the number of days, hours, and minutes between NOW and Oct 7. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
real-time countdown | Excel Worksheet Functions | |||
I have a countdown set up in Excel, how can I move it to desktop? | Excel Discussion (Misc queries) | |||
Is a countdown timer possible? | Excel Discussion (Misc queries) | |||
need to show date countdown | Excel Worksheet Functions | |||
Display a countdown timer | Excel Worksheet Functions |