software

I have the simplest of formulas to give me the time until an event takes
place. In one cell I have the now function ( =now() ). In another cell the
date/time of the event. In a third cell the event date/time-now formula
(formatted h:mm:ss). It works fine but I have to hit F9 to recalculate.
Can I get it to display a constantly updating time showing the seconds
ticking away? Also how can I get it to show the months and days away an
event is in addition to hours/min/sec?

Thanks... Bob
www.mvps.org/dmcritchie/excel...ime.htm#clocks

look for real time clock

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Bob Newmanquot; gt; wrote in message
news:2qeEf.1848$c64.535@dukeread12...
gt;I have the simplest of formulas to give me the time until an event takes
gt;place. In one cell I have the now function ( =now() ). In another cell
gt;the date/time of the event. In a third cell the event date/time-now
gt;formula (formatted h:mm:ss). It works fine but I have to hit F9 to
gt;recalculate. Can I get it to display a constantly updating time showing the
gt;seconds ticking away? Also how can I get it to show the months and days
gt;away an event is in addition to hours/min/sec?
gt;
gt; Thanks... Bob
gt;I must not have made myself clear. I am not looking for a clock. I want a
cell in an Excel 2003 spreadsheet to display the time (counting down) until
an event (date amp; time) in another cell of that spreadsheet.

Bob

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; www.mvps.org/dmcritchie/excel...ime.htm#clocks
gt;
gt; look for real time clock
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Bob Newmanquot; gt; wrote in message
gt; news:2qeEf.1848$c64.535@dukeread12...
gt;gt;I have the simplest of formulas to give me the time until an event takes
gt;gt;place. In one cell I have the now function ( =now() ). In another cell
gt;gt;the date/time of the event. In a third cell the event date/time-now
gt;gt;formula (formatted h:mm:ss). It works fine but I have to hit F9 to
gt;gt;recalculate. Can I get it to display a constantly updating time showing
gt;gt;the seconds ticking away? Also how can I get it to show the months and
gt;gt;days away an event is in addition to hours/min/sec?
gt;gt;
gt;gt; Thanks... Bob
gt;gt;
gt;
I have a workbook that shows a countdown timer. Mail me direct if you want a
copy

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

do the obvious with the bits in brackets

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Bob Newmanquot; gt; wrote in message
news:6JeEf.1852$c64.351@dukeread12...
gt; I must not have made myself clear. I am not looking for a clock. I want
a
gt; cell in an Excel 2003 spreadsheet to display the time (counting down)
until
gt; an event (date amp; time) in another cell of that spreadsheet.
gt;
gt; Bob
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt; gt; www.mvps.org/dmcritchie/excel...ime.htm#clocks
gt; gt;
gt; gt; look for real time clock
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Bob Newmanquot; gt; wrote in message
gt; gt; news:2qeEf.1848$c64.535@dukeread12...
gt; gt;gt;I have the simplest of formulas to give me the time until an event takes
gt; gt;gt;place. In one cell I have the now function ( =now() ). In another cell
gt; gt;gt;the date/time of the event. In a third cell the event date/time-now
gt; gt;gt;formula (formatted h:mm:ss). It works fine but I have to hit F9 to
gt; gt;gt;recalculate. Can I get it to display a constantly updating time showing
gt; gt;gt;the seconds ticking away? Also how can I get it to show the months and
gt; gt;gt;days away an event is in addition to hours/min/sec?
gt; gt;gt;
gt; gt;gt; Thanks... Bob
gt; gt;gt;
gt; gt;
gt;
gt;