Scroll down to the part: Using a worksheet event macro
You can't use formulas as the "date/time stamps" as these will recalc

You scrolled right past "Using circular references and worksheet functions".


--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
(You can't use formulas as the "date/time stamps" as these will recalc)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gusdafa" wrote in message
...

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