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

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

--
---
HTH

Bob


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



"NED" wrote in message
...
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

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" wrote in message
...
=DATE(2008,1,1)-TODAY()

--
---
HTH

Bob


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



"NED" wrote in message
...
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

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" <groups [at] biddulph.org.uk wrote in message
...
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" wrote in message
...
=DATE(2008,1,1)-TODAY()

--
---
HTH

Bob


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



"NED" wrote in message
...
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