How to use SECOND Function in Excel

how to use excel second function

Quick Intro

Use Excel SECOND Function to extract a number from a time value representing seconds, range from 0 to 59. In simple words, It will return seconds from a time.

For example from 10:45:23 PM it will return 23.



  • serial_number A time value with seconds from which you want to extract seconds. You also insert that time value directly into the function using double quotation marks.

More Information on Excel SECOND Function

  • Excel stores date as a number. “22-Apr-2016 12:33:10 PM” will represent “42482.5230324074” as a number.
  • Integer part represents date and decimal part represent time.
  • You can directly insert time value into the function.


In the below example, I have used different input value to get second. Input value should be a valid date & time as per excel’s date & time system. An input value which has no value of seconds in it will return 0 as a result.

Examples For Excel SECOND Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel SECOND Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There are also you have HOUR | MINUTE functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.