Time or row cell updated
I have an XLS which is updated throughout the day with new rows of data.
I want to capture the time each row is input. Ideally when a specific
cell is input I want to put the associated time at the end of the row
soI can calculate the time between each row. I have tried the obvious
=NOW() function but ever time the sheet recalculates the times change.
Is there a way to capture the current time but not update it when the
sheet re-calculates?
--
525047
|