Will Excel's time display do this?

[Bob Newman]

(Sorry if this is a cross post)
Excel 2003

I need a cell to display the "time until" an event. I set it up using to
cells, a simple "=now()" function in one and the date/time of the event in
the other & a 3rd cell with the event cell minus the now cell (formatted
h:mm:ss). Two questions please. First & most important, this works okay
for the event (same day as now) but I have to keep hitting F9 to recalc for
it to be accurate. Is there a way to have de destination cell "running"
constantly so you can see the seconds ticking down continuously? Also
(unrelated to the 1st question) instead of showing hours/minutes/seconds
until the event in one cell, can I break it up into several? I.e.; days,
hour, minutes, seconds until event in separate cells? (or another way if the
event is several days from now).

Thanks in advance... Bob

[Bob Phillips]

Bob,

I have a countdown example workbook. If you want a copy, mail me direct

bob (dot) phillips (at) tiscali (dot) co (dot) uk

do the obvious with the bits in brackets

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bob Newman" <bob.newman@cox.net> wrote in message
news:B7BDf.401$c64.112@dukeread12...
> (Sorry if this is a cross post)
> Excel 2003
>
> I need a cell to display the "time until" an event. I set it up using to
> cells, a simple "=now()" function in one and the date/time of the event in
> the other & a 3rd cell with the event cell minus the now cell (formatted
> h:mm:ss). Two questions please. First & most important, this works okay
> for the event (same day as now) but I have to keep hitting F9 to recalc
for
> it to be accurate. Is there a way to have de destination cell "running"
> constantly so you can see the seconds ticking down continuously? Also
> (unrelated to the 1st question) instead of showing hours/minutes/seconds
> until the event in one cell, can I break it up into several? I.e.; days,
> hour, minutes, seconds until event in separate cells? (or another way if
the
> event is several days from now).
>
> Thanks in advance... Bob
>
>