software

Sorry if this is a crosspost. (Excel 2003)

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
It is multiposting and it is considered bad etiquette

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Bob Newmanquot; gt; wrote in message
news:TqeEf.1849$c64.1378@dukeread12...
gt; Sorry if this is a crosspost. (Excel 2003)
gt;
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
gt; the seconds ticking away? Also how can I get it to show the months and
gt; days away an event is in addition to hours/min/sec?
gt;
gt; Thanks... Bob
gt;Yes, I know. That's why I apologized in advance. I wasn't sure as to the
correct group.

Bob

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; It is multiposting and it is considered bad etiquette
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:TqeEf.1849$c64.1378@dukeread12...
gt;gt; Sorry if this is a crosspost. (Excel 2003)
gt;gt;
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;
It's better to cross post which is one message in multiple groups, that way
any responder will see other responses as well. If I were to spend half an
hour to help somebody only to find out he/she received the same answer in
another group I would be very ****ed off

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Bob Newmanquot; gt; wrote in message
news:CKeEf.1853$c64.236@dukeread12...
gt; Yes, I know. That's why I apologized in advance. I wasn't sure as to the
gt; correct group.
gt;
gt; Bob
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt;gt; It is multiposting and it is considered bad etiquette
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:TqeEf.1849$c64.1378@dukeread12...
gt;gt;gt; Sorry if this is a crosspost. (Excel 2003)
gt;gt;gt;
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;