| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help - Information with time and date
I have a spressheet that automatically populates 2 cells with the current
time and date using the TODAY() and NOW () functions. Unfortunately, when I go back into the sheet at a later date or time it repopulates the cells with the new time and date. e.g. First Visit date set to 5-Jan 05 and time set to 09:20 AM. Second visit date set to 5-Jan 05 and time set to 09:25 AM. Third visit date set to 6-Jan 05 and time set to 10:00 AM. Is there a way that I can only get the cells populated once? Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Date and Time Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
