SECOND function - The function returns the second part of a time value in Excel

The following article introduces you to the SECOND function - one of the functions in the date and time group is very popular in Excel.

SECOND function - The function returns the second part of a time value in Excel Picture 1

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:

SECOND function - The function returns the second part of a time value in Excel Picture 2

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

SECOND function - The function returns the second part of a time value in Excel Picture 3

- Press Enter -> the result is:

SECOND function - The function returns the second part of a time value in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

SECOND function - The function returns the second part of a time value in Excel Picture 5

- 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!