The Excel SECOND Function

Basic Description

The Excel Second function returns an integer representing the seconds 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 seconds component. This may be supplied to the function as either:

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

Further information and examples of the Excel Second function are provided on 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.