Time Stamp

[Andrew C]

Hi

i wish to record in my current cell (whichever i have selected) to record
the current time. I need to show hours, minutes and seconds. I have looked
atthe Ctrl-Shift-; option but it doesnt record seconds option.

How can record this information at a push of a button

Thanks

 

[Gord Dibben]

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub

Assign the above to a button.


Gord Dibben MS Excel MVP

 

[Andrew C]

Thank you works great

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub

Assign the above to a button.


Gord Dibben MS Excel MVP