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" <(E-Mail Removed)> wrote in message
news:B9D65292-DD5D-4D1E-A7D0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:eoEtcl%(E-Mail Removed)...
> =DATE(2008,1,1)-TODAY()
>
> --
> ---
> HTH
>
> Bob
>
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
>
>
> "NED" <(E-Mail Removed)> wrote in message
> news:B9D65292-DD5D-4D1E-A7D0-(E-Mail Removed)...
>> 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
news:475e7619$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:eoEtcl%(E-Mail Removed)...
>> =DATE(2008,1,1)-TODAY()
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>>
>>
>> "NED" <(E-Mail Removed)> wrote in message
>> news:B9D65292-DD5D-4D1E-A7D0-(E-Mail Removed)...
>>> 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
>>
>>
>
>