SECOND (second)

<< Click to Display Table of Contents >>

SECOND (second)

Syntax:

SECOND(Time)

Description:

This returns the seconds of a time value.

Example:

SECOND("12:34:56 AM") returns 56

SECOND("09/25/2018 10:30:36") returns 36

If cell A1 contains a date with the time 10:30:36, then SECOND(A1) returns 36

See also:

HOUR, MINUTE, MILLISECONDS