Returns the seconds component, as an integer, for the given time value.
Sample Usage
SECOND("14:25:30")
SECOND(C5)
Syntax
SECOND(time)
- time - The time from which to calculate the second.
Examples
SECOND("14:25:30") returns the seconds component, which is 30.
SECOND(C5) returns the seconds component of the time value contained in C5.
Notes
- Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object, or a date serial number.
- SECOND does not auto-convert number formats. Therefore, SECOND(12:00:00) will return an error.