Thanks for the reply Niek. I tried that before and it's not working for
what I want it to do.

What I am trying to do is I have a list of 100 #s in column A. Once I
get done working the first # (in A1). I want to put "1" in B1. Once
"1" is entered I want C1 to show the current time. I'll repeat the
steps, finish A2, put "1" in B2 and the current time will show in C3.


With the previous formula: =IF(A1=1,NOW(),"")

C1, C2, C3 and so on would be the same time, updating everytime you
input a "1" if the time change. Is there something that can be changed
w/ the current formula, or is there another formula out there?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539501