SECOND
Formulas / SECONDReturn 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?
What does the SECOND function take as its argument?
What does the SECOND function return?
What types of time values can I use with the SECOND function?
