Inserting current time
Posted by John R on February 13, 2002 4:32 AM
I am trying to put together a spreadsheet to record the time an entry is made into a neighboring cell.
Ideally as I enter the values in a1, the time of entry will appear in a2. I have tried using
=IF(A1=0,".",NOW())for a2, but when I enter the next value in b1, the time in a2 is updated to the current time, and not left as the time a1 was enetered.
Is there anyway to get excel not to update previously entered times, or is there another way round this problem?