Excel SECOND Function

HomeExcel FunctionsExcel SECOND Function (Example + Sample File)

What is EXCEL SECOND FUNCTION

The Excel SECOND Function is listed under Microsoft Excel's Time Functions category. It returns the seconds value from a valid time. Time value is made up of, hours, minutes, and seconds and SECOND function takes seconds value and ignores the rest of all.

How to use it

To learn how to use the SECOND function in Excel, you need to understand its syntax and arguments: 

Syntax

SECOND(serial_number)

Arguments

  • serial_number: A valid time from which you want to get the second value.

Notes

  • Integer part represents date and decimal part represents time.

Example

To master the SECOND function we need to try it out in an example and below is one which you can try out:

In the below example, we have used different input value to get second. The input value should be a valid date and time as per Excel’s date and time system.

An input value that has no value of seconds in it will return 0 as a result.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.