The SECOND returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

SECOND takes 1 required argument and no optional arguments:

Syntax: SECOND(serial_number)

#1)
Using the SECOND function:
#2)
The arguments for the SECOND function are:
Argument Required? Description
serial_number Required The time that contains the second you want to find. Times may be entered as text strings within quotation marks (for example, "7:30 AM"), as decimal numbers (for example, 0.3125, which represents 7:30 AM), or as results of other formulas or functions (for example, TIMEVALUE("7:30 AM")).

Summary

The SECOND returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.
comments powered by Disqus