Hi there,

I have a formula that updates the time wherever data is entered in the
B15 cell. I copied this formula down the column so that each update
(B16..B17) will have its on time update, the problem is that the latest
time update updates all the previous times to the current time. Can
someone help me rectify this please? I want times updated previously to
be locked and not updated anymore. I have tried locking nearly
everything in the formula but got thrown errors.

Here is the formula,
=IF(B15<"",TIME(HOUR(NOW()),MINUTE(NOW()),SECOND( NOW())),"")

Thanks.




--
gusdafa