Try this if you don't want to use a macro. Change accordingly:
=IF(B3="","",IF(C3="",NOW(),C3))
Tool/Options/Calculations/Check Aterations

"525047" wrote:


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