You are on the Home/Excel/Excel Tips/Enter time with seconds page
Web This Site

Enter time in seconds

Do you want to enter the current time in a cell so that it doesn't change each time Excel recalculates formulas?  Then, use CTRL+SHIFT+:  However, Excel only provides the time in hours and minutes or HH:MM.  To enter the time so that it includes seconds, one has to override the default behavior.

Enter the code below in a standard module:

Option Explicit
Sub setKey()
    Application.OnKey "+^:", "EnterTime"
    End Sub
Sub resetKey()
    Application.OnKey "+^:"
    End Sub
Sub EnterTime()
    With ActiveCell
    .Value = Time()
    .NumberFormat = "hh:mm:ss"
        End With
    End Sub

Now, once you run the setKey procedure, the CTRL+SHIFT+: will give you the time in seconds. To return Excel to its default behavior, run the resetKey procedure.