Microsoft Office Forums - View Single Post - Format number for time , hh:mm:ss,,,second appears 00

rollis13 · 04-25-2021, 12:31 AM

That's it, if Time is inserted with the keyboard shortcut the seconds will always be :00 .
The only workaround I know is to use a macro and assign it to a key combination.
Example: Ctrl+t (t for time

)

Code:

Option Explicit
Sub Data()
    ActiveCell.Value = Format(Now(), "hh:mm:ss")
    'ActiveCell.Value = Format(Time(), "hh:mm:ss")
End Sub