Return cuurent time when another cell is updated

		Microsoft Office Forums > Microsoft Excel > Excel
Return cuurent time when another cell is updated

01-20-2012, 10:31 AM

zks

Windows XP Return cuurent time when another cell is updated

Office 2003

Novice

Join Date: Jan 2012

Posts: 3

SOLVED....

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

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
How can references be updated automatically?	ezthelm	Word	2	05-30-2011 03:45 AM
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:55 AM.