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