SECOND

  • Updated

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.