General discussion


Time Stamp Capturing

By amit.suneja ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by amit.suneja In reply to Time Stamp Capturing

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:
3. Apply \"mm/dd/yyyy hh:mm\" format to column B.

Related Discussions

Related Forums