count day timer

N

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
 
B

Bob Phillips

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

--
---
HTH

Bob


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

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.
 
B

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)



David Biddulph said:
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

Bob Phillips said:
=DATE(2008,1,1)-TODAY()

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...
Click to expand...
 
Top