Adding Time Cell Was Changed

[Andy Rads]

Column A has different values (these are not important). In column B I want
to show the time that say cell A1 was changed. I have tried several methods
but all result in all the times in column B being changed to the same time.
Can anyone help?

Many thanks.

 

[JE McGimpsey]

see

http://www.mcgimpsey.com/excel/timestamp.html

 

[Héctor Miguel]

hi, Andy !

... In column B I want to show the time that say cell A1 was changed.
I have tried several methods but all result in all the times in column B being changed to the same time...

here is another approach, defining/using a [tricky] UDF as follows:

Function Change_Time(myCell As Range) As Date
Volatile = False
Change_Time = Now
End Function

you could use the above UDF [i.e.] in 'B1'...
=if(a1<>"",change_time(a1))

you might need to format 'B1' like: h:mm:ss.0000

hth,
hector.