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:
- Select the cell where you want to insert the current time.
- Type =NOW()
- Press Enter.
- Right-click the cell, and then click Format Cells.
- Under Category, click Custom.
- In the Type box, type h:mm:ss
- Click OK.