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


"bigguy68" wrote:

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