Excel Guides

Inserting the Current Time with Seconds in Excel

You can insert the current time with seconds in Excel by using the NOW function. The NOW function returns the current date and time as a serial number. To display the current time with seconds, you need to format the cell using a time format that includes seconds. For example, you can use the following time format: h:mm:ss

To insert the current time with seconds, follow these steps:

  1. Select the cell where you want to insert the current time.
  2. Type =NOW()
  3. Press Enter.
  4. Right-click the cell, and then click Format Cells.
  5. Under Category, click Custom.
  6. In the Type box, type h:mm:ss
  7. Click OK.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.