Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running/Current time in cell?
I know that if I enter CTRL+SHIFT; it will enter the current time of day.
But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#2
|
|||
|
|||
Just type =Now() into the cell.
************ Anne Troy www.OfficeArticles.com "SRS" wrote in message ... I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#3
|
|||
|
|||
=NOW()
George Gee SRS wrote: I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#4
|
|||
|
|||
SRS
If you wish to display the time only, without the date: Format ? Cells Number tab highlight 'Time' on the left, and make your choice from the right. HTH George Gee SRS wrote: I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#5
|
|||
|
|||
Which will update only when calculation takes place.
Or do you actually want to see the seconds ticking by? Would take VBA and resources to have that occur. Gord Dibben Excel MVP On Wed, 28 Sep 2005 16:17:00 -0400, "Anne Troy" wrote: Just type =Now() into the cell. ************ Anne Troy www.OfficeArticles.com "SRS" wrote in message ... I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#6
|
|||
|
|||
Anne & George:
Thank you! "George Gee" wrote: =NOW() George Gee SRS wrote: I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
#7
|
|||
|
|||
Thank you for clarifying...I have no clue about VBA (remember, this forum is
titled "New User" :) ..... so the =NOW() formula will work for now. Thanks to all for such quick help! "Gord Dibben" wrote: Which will update only when calculation takes place. Or do you actually want to see the seconds ticking by? Would take VBA and resources to have that occur. Gord Dibben Excel MVP On Wed, 28 Sep 2005 16:17:00 -0400, "Anne Troy" wrote: Just type =Now() into the cell. ************ Anne Troy www.OfficeArticles.com "SRS" wrote in message ... I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the current time???) Just wondering........ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining date and time into one cell | Excel Discussion (Misc queries) | |||
Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
calculating with a time format cell | Excel Worksheet Functions |