Return the second component of a time as a number between 0-59.

`SECOND(serial_number)`

- serial_number - required argument to find the time with the seconds

`=SECOND(A3)`

The SECOND function is used to return the seconds of a time value. In this example, the formula will return 18 because A3 is 4:48:18 PM and 18 is the seconds in 4:48:18 PM.

`=SECOND(NOW())`

The SECOND function can also be used with the NOW function. The NOW function returns the current date and time. For example, the formula will return the number of seconds from the current time.

`=SECOND(TIME(HOUR(A3),MINUTE(A3),0))`

The SECOND function can also be combined with other time functions. For example, the formula will return the number of seconds from a time value in A3.

`=SECOND(DATEVALUE("3/12/2020 8:45:33"))`

The SECOND function can also be used to return the seconds from a date and time value. For example, the formula will return the number of seconds from the date and time value 3/12/2020 8:45:33.

The SECOND function returns the seconds from a time value, which can be provided as a text string. It is a useful tool to quickly extract the seconds from a time value.

- The
**SECOND**function returns a number between 0-59 that represents the second component of a time, which can be extracted from a cell. - The result of
**SECOND**can be used to feed other formulas, such as the TIME function.

The SECOND function returns the seconds from a time value.

The SECOND function takes a time value as its argument. The time value may be a text string within quotation marks or a decimal number.

The SECOND function returns an integer in the range 0 to 59.

You can use text strings as times.

Drop CSV