Inserting time with ctrl+shift+: always shows 00 for seconds

  • Thread starter Thread starter JimK
  • Start date Start date
J

JimK

Whenever I use the shortcut ctrl+shift+: to enter the current time, th
seconds are always 00 instead of whatever the system clock shows.

I need the current, real-time seconds to show.

Is this possible?

Using Excel 2000
 
I don't know of a way to modify how Excel does this. You could run a macro
instead of using that shortcut:

Sub InsertTime()
With ActiveCell
.Value = Now
.NumberFormat = "h:mm:ss"
End With
End Sub
 
Back
Top