Summary
The Excel SECOND function returns the second component of a time as a number between 0-59.
Purpose
Get the Second as a number (0-59) from a Time
Return value
A number between 0 and 59
Syntax
=SECOND (serial_number)
Arguments
- serial_number – A valid time in a format Excel recognizes.
Usage notes
Times can be supplied as text (e.g. “8:45 PM”) or as decimal numbers (e.g. 0.5, which equals 12:00 PM).
Excel stores dates and times as serial numbers.