Second function

Description

This function returns the second component of a time as a number between 0 - 59. The SECOND function is to extract the second into cell, or feed the result into another formula like the TIME function.

​

Objective

Returns the second as a number from 0 to 59.

​

Syntax

=SECOND(serial_number)

​

Arguments

serial_number - Valid time used by Excel.

​