# How to Use Excel 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:

https://www.microsoft.com/en-in/microsoft-365/excel

## 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.

## Syntax

• 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 button to get the result.

=SECOND(serial_number)

Argument Description:

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

## Examples

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.
• After that, you have to apply the above-mentioned formula in order to get the result, as shown in the below image.
• To get the result, you will need to click on the 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.

## Verdict

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 Aawexcel.com.

## Video Tutorial

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

Also Know:

Tags: