One way:

Public Sub InsertTime()
With ActiveCell
.Value = Time
.NumberFormat = "hh:mm:ss"
End With
End Sub


In article ,
rglasunow
wrote:

I am trying to create a macro that records the current time off the
clock on my computer. I am aware of the short cut (ctrl+shift+;).
However, this does not go into the actual seconds. Is there a way to
record the seconds as well?