How to Use the SECOND Function in Excel

This guide explains how to use SECOND Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the second part of the time value. The second value is an integer, and has a value between 0 and 59 seconds.

Syntax: SECOND (serial_number)

Inside:

- serial_number is the time value containing the seconds you want to find. Time values can be entered as strings or decimals.

Attention:

- The time value is part of the date value and is expressed as a decimal. For example, 0.5 is half a day, 12 hours = 720 minutes = 43200 seconds.

For example:

Find the seconds value in the following time values:

- In the cell to calculate enter the formula: = SECOND (F7).

- Press Enter -> the result is:

- Similarly copying the formula for the remaining values results:

- Here:

+ Time value does not contain the second component -> gives the number of seconds is equal to 0.

+ Time value: 37:50:38 -> Total time corresponds to hours: minutes: seconds.

+ Value 42: 56.3 -> minutes: seconds. If the seconds value contains a decimal value greater than or equal to 5 -> is rounded up. Example 52.9 is rounded to 53 seconds.

Above are instructions and some specific examples when using the SECOND () function in Excel.

Good luck!