The following article introduces you to the SECOND function - one of the functions in the date and time group is very popular in Excel.
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!