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.

see

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

In article <532607C4-B90C-4963-81DB-(E-Mail Removed)>,
"Andy Rads" <(E-Mail Removed)> wrote:

> 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.

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.