Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel, have time of day appear automatically.
Hello. I would like to create a simple Excel (2002) worksheet that
automatically inserts the time of day into the first cell in each row whenever, and only when, the cursor is moved to a new row. The application for this is an ongoing log of activity that may stretch out over several hours or all day long. It would save the typing effort and any possible errors in typing in order to have each line start with the time of the event being logged. Thank you for any replies. |
#2
|
|||
|
|||
How about when the user actually makes an entry in a cell in that row???
That seems a little safer to me. And if you like that idea, you can steal some code from J.E. McGimpsey: http://www.mcgimpsey.com/excel/timestamp.html Teddy Reddy wrote: Hello. I would like to create a simple Excel (2002) worksheet that automatically inserts the time of day into the first cell in each row whenever, and only when, the cursor is moved to a new row. The application for this is an ongoing log of activity that may stretch out over several hours or all day long. It would save the typing effort and any possible errors in typing in order to have each line start with the time of the event being logged. Thank you for any replies. -- Dave Peterson |
#3
|
|||
|
|||
Dave,
Your way is better, and, as you say, "safer". Thank you for the useful reference. I have some studying to do! -Teddy "Dave Peterson" wrote: How about when the user actually makes an entry in a cell in that row??? That seems a little safer to me. And if you like that idea, you can steal some code from J.E. McGimpsey: http://www.mcgimpsey.com/excel/timestamp.html Teddy Reddy wrote: Hello. I would like to create a simple Excel (2002) worksheet that automatically inserts the time of day into the first cell in each row whenever, and only when, the cursor is moved to a new row. The application for this is an ongoing log of activity that may stretch out over several hours or all day long. It would save the typing effort and any possible errors in typing in order to have each line start with the time of the event being logged. Thank you for any replies. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automatically opens files | Excel Discussion (Misc queries) | |||
Excel sheet for workout jogging time and graph | New Users to Excel | |||
More than 1 MS Excel Open at a time | Setting up and Configuration of Excel | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions |