Hello all,
What I need is a way for a cell to automatically insert the actual time information was entered into another cell, without erasing a previous time already calculated. In the example below, information was entered in B2 at 1:30 PM, so the time showed in A2. At 1:40 PM, information was entered in C3, so 1:40 PM populated in A3. At this point, nothing has been entered in any other cells, therefore, no time shows in any more cells in column A. But, once I do put something in either column B or C, I need the current time to populate in Column A without disturbing the times that are already entered in A2, A3, etc.
If this is possible, that you very much in advance.
<tbody>
</tbody>
What I need is a way for a cell to automatically insert the actual time information was entered into another cell, without erasing a previous time already calculated. In the example below, information was entered in B2 at 1:30 PM, so the time showed in A2. At 1:40 PM, information was entered in C3, so 1:40 PM populated in A3. At this point, nothing has been entered in any other cells, therefore, no time shows in any more cells in column A. But, once I do put something in either column B or C, I need the current time to populate in Column A without disturbing the times that are already entered in A2, A3, etc.
If this is possible, that you very much in advance.
A | B | C | |
1 | Time | Info 1 | Info 2 |
2 | 1:30 PM | new information written here | |
3 | 1:40 PM | new information written here | |
4 | |||
5 |
<tbody>
</tbody>