Forum Discussion
Record Time of Entry
Is there a way to record the time of data entries in a cell? So, I would like the cells in column A to record the time, as I enter data in the cells of column B. It seems possible, I just haven’t ...
There's a function called NOW() which will get the current date and time.
The issue is that it updates every time the worksheet is recalculated.
To use that function but keep the time shown static as you add new rows, you can use iterative calculation to allow a circular reference to keep the value in the cell if it's already there.
Go to File>Options>Formulas and enable iterative calculation:
Now, in A2, you can put this formula:
=IF(B2<>"",IF(A2<>"",A2,NOW()),"")
You'll see that this formula is checking if there's a value in B2. If there is, it's checking if there's already a value in A2 (where the formula is). If there is already a value, it leaves it alone. If there isn't a value, it uses the NOW() function to get the current time.
Example workbook attached.