I really appreciate the info. However, I'm not very saavy with this sort of
thing. In fact, I don't even know how to begin altering the setup like this.
If you wouldn't mind, could you take me through how to do this step by step?
Thanks.

"JE McGimpsey" wrote:

This is a peer-to-peer newsgroup.

To submit suggestions to MS, send an email to .

FWIW, my default setup does exactly that. In my startup template (in the
startup folder) I have something like:

Private Sub Workbook_Open()
Application.OnKey "^+;", "EnterTime"
End Sub

and in a regular module:

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





In article ,
"JoeGill" wrote:

The shortcut to enter the current time in an Excel workbook should include
seconds. Currently, if you hit CTRL+: (SHIFT ;) the current time is
displayed in the appropriate cell as 1:14 PM b default. Formatting the time
to read h:mm:ss, it is displayed with the seconds as :00