Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
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: |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running clock
If you read through this posting you will find a couple of
suggestions. For the OnTime method see Chip Pearson's site for code. http://www.cpearson.com/excel/OnTime.aspx Or just use Bob Phillips' timer addin...............posted below. Gord Dibben Microsoft Excel MVP On Mon, 08 Aug 2011 10:55:37 GMT, Tuan Kamileen Yaheya 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 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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Clock | Excel Discussion (Misc queries) | |||
How do I calculate time in excel (clock in and clock out | Excel Discussion (Misc queries) | |||
A running clock | Excel Worksheet Functions | |||
Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
Start Clock/Stop Clock | Excel Discussion (Misc queries) |