View Single Post
 
Old 01-20-2012, 09:17 AM
zks zks is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2012
Posts: 3
zks is on a distinguished road
Default Return cuurent time when another cell is updated

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
Reply With Quote