The Excel SECOND Function

Function Description

The Excel Second function returns an integer representing the second component of a supplied Excel time.

The syntax of the function is:

SECOND( serial_number )

where the serial_number argument is the time from which you want to extract the second component. This may be supplied to the function as either:

• A decimal (serial number) representation of an Excel time;
• A text representation of a time;
• A reference to a cell containing a time;
• A time value returned from another Excel function or formula.

Note that, if the serial_number argument is composed of a date and time, the date part of the argument is ignored by the Second function.

Second Function Examples

Four examples of the Excel Second function are shown in column B of the following spreadsheet.

Formulas:
AB
1 =SECOND( "13:35:55" )
213:35:55=SECOND( A2 )
308:17:00=SECOND( A3 )
412/09/2011 08:17:23=SECOND( A4 )
Results:
AB
1 55
213:35:5555
308:17:000
412/09/2011 08:17:2323

For further information and examples of the Excel Second function, see the Microsoft Office website.

Second Function Error

If you get an error from the Excel Second Function, this is likely to be the #VALUE! error:

Common Error
 #VALUE! - Occurs if the supplied serial_number is not a valid Excel time.