How to Auto Update Current Time in Excel (3 Easy Ways)

Method 1 – Using the NOW Function 

Steps:

• Select cell C4 and enter this formula:

• Press Enter.

• It will enter the current time on the cell taken from your computer.

Each time you change your workbook, the formula will recalculate automatically and update the current time.

Read More: How to Insert Current Date and Time in Excel

Method 2 – Applying VBA Code

Steps:

• Press ALT+F11. The VBA window will open from the Developer tab.

• Go to the Insert tab in the VBA window. 
• From the options available, select Module.

• A new module window called “Module 1” will open. 
• Insert the following VBA code in the module and save it by pressing Ctrl+S:

Dim SchedRecalc As Date
Sub Recalc()
With Sheet1.Range("C3")
.Value = Format(Time, "hh:mm:ss AM/PM")
End With
Call SetTime
End Sub
Sub SetTime()
SchedRecalc = Now + TimeValue("00:00:01")
Application.OnTime SchedRecalc, "Recalc"
End Sub
Sub Disable()
On Error Resume Next
Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False
End Sub

• Return to your worksheet and press ALT+F8.
• A dialogue box called Macro will open.
• Select SetTime and click on Run.

• You will find the current time being entered in your desired cell and updating every second, just like a running clock.

• If you want to stop the clock, press ALT+F8.
• Select Disable.
• Click Run.

• The clock will stop running.

We will get a dynamic clock showing the updated time.

Read More: Excel Current Time Formula

Method 3 – Utilizing a Keyboard Function

Steps:

• Choose cell C4 and press Ctrl+Shift+
• The latest time from your computer will be in cell C4.

Download the Practice Workbook

Related Articles

• How to Insert Timestamp in Excel When Cell Changes
• How to Insert Excel Timestamp When Cell Changes Without VBA
• How to Add Date and Time in Excel When Printing
• How to Insert Last Modified Date and Time in Excel Cell
  
• How to Enter Date and Time in Excel
• How to Combine Date and Time in One Cell in Excel

<< Go Back to Timestamp | Date-Time in Excel | Learn Excel