SECOND

Returns the second component of a time as a whole number, so SECOND of 09:45:22 gives 22. It is the last of the three functions, with HOUR and MINUTE, that take a time apart.

When to use

Give the result cell the General format because it is a plain whole number. It is the counterpart of TIME, which builds a time from its parts.

See Lec 05.

Appears in

No references yet.