Capture total time when change value in cell in worksheet

[Josephchari]

Dear All,

Pls help to advice macro for below:
1. When Input value "A" in cell A1 ---> date stamp in B1
2. Change value "A" to "B" in cell A1 ---> capture total time from beginning input value "A" to time change value "B" ---> date stamp in C1
3. Again change value "B" to "C" in cell A1 ---> capture total time from beginning input value "A" to time change value "C" ---> date stamp D1
4. Again change value "D" to "E" in cell A1 ---> capture total time from beginning input value "A" to time change value "D" ---> date stamp D1
5. Again change value "E" to "F" in cell A1 ---> capture total time from beginning input value "A" to time change value "F" ---> date stamp D1
...
Thank you!

[adyteo]

have a look at this:
DateStamp.xlsm

[Josephchari]

Thanks adyteo,

* When the value third changed, date stamp is changed in only 1 cell (D1). pls see step 3,4,5
Your code is every value changed, date stamp is in different cell.
* And how to lock not allow edit manually by user, but macro is still can run?

3. Again change value "B" to "C" in cell A1 ---> capture total time from beginning input value "A" to time change value "C" ---> date stamp D1
4. Again change value "D" to "E" in cell A1 ---> capture total time from beginning input value "A" to time change value "D" ---> date stamp D1
5. Again change value "E" to "F" in cell A1 ---> capture total time from beginning input value "A" to time change value "F" ---> date stamp D1

have a look at this:
Attachment 326807

[adyteo]

replace the code from my excel file with this updated code:

Please Login or Register  to view this content.