For example, given a time of “12:15:01”, SECOND will return 1.
“7:45:30 PM”).
The SECOND function does not convert time into seconds but ratherextractsthe seconds component from time.
This means the SECOND function will “reset” to 0 every 60 seconds (like a clock).
To convert a time value into decimal seconds,see this example.
Fractional seconds
One notable limitation of the SECOND function is that itroundsfractional seconds to the nearest second.
it’s possible for you to see this behavior in the worksheet below.
The TIME function is useful when you want to assemble a proper time inside another formula.
