Discussion Locked

Time Stamp Capturing

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to capture time stamp for each cell entry in a particular column and i have around 150 rows in that column and i want when ever a value is entered in any row in that column i get the time of entry capture on any other cell and it should not change if an entry is made in any other rows in that columns, please help me for this as i have been trying to solve this for many days now.

1 reply

by amit.suneja

Tanks for no help from the users of this site...

Any ways i have found a sol. that is working for me and i'm posting it here as some one else can use it:

1. Go to Tools  Options  Calculation Tab  Check the Iteration checkbox.
2. Use the IF and NOW functions as shown in the following formula:
=IF(A2="","",IF(B2="",NOW(),B2))
3. Apply \"mm/dd/yyyy hh:mm\" format to column B.

This discussion is closed to new replies.