Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2012, 09:17 AM
zks zks is offline Return cuurent time when another cell is updated Windows XP Return cuurent time when another cell is updated Office 2003
Novice
Return cuurent time when another cell is updated
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Return cuurent time when another cell is updated Cell formatting for time - Excel 2010 PomDave Excel 5 09-05-2011 10:49 PM
Item Already updated simon@resultsoftware.co.u Outlook 0 07-25-2011 04:30 AM
Return cuurent time when another cell is updated How can references be updated automatically? ezthelm Word 2 05-30-2011 03:45 AM
Return cuurent time when another cell is updated Add a period of time to a referenced "Time" cell? derelyth Excel 4 03-27-2011 04:31 PM
Outlook 2002 duplicating updated calendar events RMTony Outlook 0 12-29-2010 11:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft