Return cuurent time when another cell is updated

[zks]

I have a unsolved issue with this problem:

There is a table with a lot of data, and some of them we change couple of times. I want to have a cell(s) where I can get the time (hh:mm:ss) when that cell was filled with data (this cell is empty). (Exp: A1 is empty. At 07:25:33 I entered a data in A1. I want to have this time (07:25:33) at B1 cell. Before I print this report (last update Exp: 15:20:25) i will have a cell (C1) where I will use =Now() and I will got 15:20:25. My point is to have, at D1, how much time I was working on this sheet D1:=C1-B1!

I need a help with this!

Thanks

[TMS]

You could do this with a Worksheet Change event macro. Do you want a VBA solution?


Regards, TMS

[Pepe Le Mokko]

Cross post
http://www.msofficeforums.com/excel/...l-updated.html

Also duplicate

http://www.excelforum.com/excel-misc...37#post2687437

[zks]

SOLVED....

B1=IF(A1<>"",IF(B1="",NOW(),B1),"")

Thanks friends, .. from all Excel forums on internet!

[royUK]

Don't bother posting again until you have read the Forum Rules