| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and time stamping multiple cells for multiple entries.
I am using EXCEL to track various activities. How can I get multiple date
and time stamps to automatically fill? For example; Cell A2 is filled in with data and cell G2 date and time stamps when cell A2 is completed. Then when the next activity is entered in cell B2 the date and time is stamped in H2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time stamping multiple cells for multiple entries.
See
http://www.mcgimpsey.com/excel/timestamp.html In article , Gerald wrote: I am using EXCEL to track various activities. How can I get multiple date and time stamps to automatically fill? For example; Cell A2 is filled in with data and cell G2 date and time stamps when cell A2 is completed. Then when the next activity is entered in cell B2 the date and time is stamped in H2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
