This post will guide you how to use Google Sheets **SECOND **function with syntax and examples.

Table of Contents

**Description**

The Google Sheets SECOND function returns the seconds of a time value. Or returns an integer value that represent the second component of a given excel time. And the return value is between 0-59.

**For example,** if you pass a time of 6:32:54 PM into SECOND function, and it will return 54. You can use this function to extract the second component from a time value.

The SECOND function can be used to get the second component of a given time in google sheets. The purpose of this function is to get the second as a number from a time and its returned values is a number that representing time. You can use the SECOND function to extract the second into a cell or you can also pass the result into another function as a new formula.

The SECOND function is a build-in function in Google Sheets and it is categorized as a Date function**.**

**Syntax**

The syntax of the SECOND function is as below:

**=SECOND (Time )**

**Where the SECOND function arguments is:**

**Time**-This is a required argument. The time from which you want to extract the second component. it may be typed as text string within quotation marks (for example, “13:52 PM”), or it can be a decimal numbers (for example, 0.5), or the result of a formula (for example, TIMEVALUE(“13.54:30 PM”)). It must be a cell reference that containing a date or time, or a function that returning a date/time type or a number.

**Note:**

- A serial date is how the google sheets stores dates and times and it represents the number of days since 1900-01-01, so the January 1, 1900 date is serial number 1 by default.
- If the
`Time`

argument is not a valid time, it will return**#VALUE!**Error. `Time`

argument can be supplied to the SECOND function as a time text string or as a decimal number. If you wish to create a time value with separate hour, minute and second, you can use the**TIME function**.

## Google Sheets SECOND Function Examples

The below examples will show you how to use google sheets SECOND Function to return the seconds of a given time value.

**1#** get the seconds from an Excel time 6:38:45, enter the following formula in Cell B1.

=SECOND("6:38:45")

**2# **Get the second portion of the date with no second portion specified, enter the following formula in Cell B3.

=SECOND("6:38")

or

=SECOND(TIMEVALUE("6:38 PM"))

It will return 0.