I am using =now() function in cell A1 and frequently press F9 to update to
current time. Is there any way to continuously show the current time running
in the cell A1.

On Wednesday, October 08, 2008 11:59 AM Te wrote:

I am using =now() function in cell A1 and frequently press F9 to update to
current time. Is there any way to continuously show the current time running
in the cell A1.


On Wednesday, October 08, 2008 12:09 PM GarysStuden wrote:

=NOW() will update whenever the spreadsheet is calculated. You can insert an
OnTime macro to automatically re-calculate every couple of seconds.
--
Gary''s Student - gsnu200806


"Ted" wrote:


On Wednesday, October 08, 2008 12:29 PM Te wrote:

Thank you for your answer. I never created a macro before. Can you show me
how. Greatly appreciated.

"Gary''s Student" wrote:


On Wednesday, October 08, 2008 2:37 PM Gord Dibben wrote:

Would you be happy with an addin with a timer?

See Bob Phillips' site

http://xldynamic.com/source/xld.XtraTime.html


Gord Dibben MS Excel MVP

wrote: