Day/Time Countdown

S

SeekingHelp

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!
 
S

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
A

Anne Troy

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
 
Top