SECOND

Formulas / SECOND
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

Examples

  • =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.


Summary

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.

Frequently Asked Questions

What is the SECOND function?
The SECOND function returns the seconds from a time value.
What does the SECOND function take as its argument?
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.
What does the SECOND function return?
The SECOND function returns an integer in the range 0 to 59.
What types of time values can I use with the SECOND function?
You can use text strings as times.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV