Skip to content

How to Use Excel SECOND Function?


SECOND FunctionPin
SECOND Function

Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. Sometimes, we entered the time as an input value, and we want to extract the Seconds.

Here, we will analyze the basic syntax and usage of the SECOND function in Excel with some examples. Get the official version of MS Excel from the following link:

Excel SECOND FunctionPin
Excel SECOND Function

Explanation of SECOND Function

  • It is one of the built-in functions in Excel.
  • The Excel SECOND Function returns the seconds from a time value.
  • It returns the output as an integer ranging from 0 to 59.


  • Here, you will see the syntax of the SECOND function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.


Argument Description:

Serial Number: It is the value from which you want to extract the “second”.


Let’s focus on some examples of the SECOND function and explore how to use it in Microsoft Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • For example, we have entered the input value in cell B3, and we will extract the seconds from it.
Input ValuePin
Input Value
  • After that, you have to apply the above-mentioned formula in order to get the result, as shown in the below image.
Enter the formulaPin
Enter the formula
  • To get the result, you will need to click on the Enter button.
  • Let’s see one more example to make it clear. In case, the input value does not contain the second’s value, it will return the value 0. You can see that in the following screenshot.


We expect that this article helped you to make use of the SECOND Function in Excel efficiently. In addition, the practical examples let you understand the usage of the SECOND function even more simpler. To learn more about Excel functions, then visit our webpage

Video Tutorial

The following video will show you how to apply the SECOND Function in Excel.

Also Know:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...