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.
=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: > 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. >
Thank you for your answer. I never created a macro before. Can you show me how. Greatly appreciated. "Gary''s Student" 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: > > > 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. > >
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 On Wed, 8 Oct 2008 09:29:02 -0700, Ted wrote: >Thank you for your answer. I never created a macro before. Can you show me >how. Greatly appreciated. > >"Gary''s Student" 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: >> >> > 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. >> >
