a running clock

[fastpaul_2003]

i am just woundering if there is a way of having a running clock and
also the date which is also up to date. i know there is crtl+shift+;
but this is just stuck at one time. can someone please show me how to
do a runnig clock.

 

[Jason Morin]

MVP Chip Pearson posted some code to do this. Check out:

http://makeashorterlink.com/?G61551786

Note: A running clock will slow down the performance of
Excel. I wouldn't recommend doing it.

HTH
Jason
Atlanta, GA

 

[JanetW]

NOW() will insert the current date/time and will update whenever the
spreadsheet is recalculated (either by changing the contents of a cell,
opening the file, or pressing F9). So if you are actively working in
the file, the time will [almost] be kept current. Short of that you'd
probably need a macro running in the background which will cost you
processor cycles.

 

[pfsardella]

Thread that contains a discussion of the downside on performance.
Offers advice on other options.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=1ade8c668e06c0d6&rnum=1

HTH
Paul