Not that I know of.

How about a one-click button and some code.

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


OR you could run the code from a shortcut key combo CRTL + T

One less keystroke.

Gord Dibben Excel MVP

On Thu, 18 Nov 2004 08:00:06 -0800, mike47338
wrote:

Is there any way to enter the current time in a selected sell by only
pressing 1 (one) key? (as opposed to Ctrl-Shift-;)