SECOND

Get the Second as a number (0-59) from a Time

SECOND

Summary 

The Excel SECOND function returns the second component of a time as a number between 0-59. 

Purpose 

Get the Second as a number (0-59) from a Time

Return value 

A number between 0 and 59

Syntax 

=SECOND (serial_number)

Arguments 

  • serial_number - A valid time in a format Excel recognizes.

Usage notes 

Times can be supplied as text (e.g. "8:45 PM") or as decimal numbers (e.g. 0.5, which equals 12:00 PM).

Excel stores dates and times as serial numbers. 

0 votes. 0 / 5