count day timer

[NED]

is there a way of adding a count day time to a cell which will take my
current time from my system clock to a date of my choice ie. time now 1.00pm
11/12/07 to 00:00:00 01/01/08

 

[Bob Phillips]

=DATE(2008,1,1)-TODAY()

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

But as the OP asked for the calculation to use the current time, then
presumably =DATE(2008,1,1)-NOW()

In either case, format the answer as number or general, and the answer is
the number of days.
If you format the answer as [h]:mm:ss it would give the answer in hours,
minutes, and seconds, or as d h:mm:ss for days, hours, minutes, seconds.

 

[Bob Phillips]

But he also use a subject of Count Day Timer. If he wants a second/minute or
even hour countdown, that formula is not sufficient on its own.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

But as the OP asked for the calculation to use the current time, then
presumably =DATE(2008,1,1)-NOW()

In either case, format the answer as number or general, and the answer is
the number of days.
If you format the answer as [h]:mm:ss it would give the answer in hours,
minutes, and seconds, or as d h:mm:ss for days, hours, minutes, seconds.
--
David Biddulph

=DATE(2008,1,1)-TODAY()

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)