Adding a time stamp

[bigguy68]

I would like to add a field that would state the time an action happened in
another cell... ei. tell me the time a field went from 0 to 1
a static time...

thanks

 

[Niek Otten]

Look here:

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to add a field that would state the time an action happened in
| another cell... ei. tell me the time a field went from 0 to 1
| a static time...
|
| thanks

 

[J. Sperry]

Assuming the time stamp should be in the cell directly to the right of the
updated field, then select the updated field and run the following macro.

Sub TimeStamp()
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "=TIME(HOUR(NOW()),MINUTE(NOW()),0)"
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
End Sub