The Excel SECOND function returns the second integer from a time serial number ranging from 0 to 59.
| Syntax: | =SECOND(serial_number) |
Where the serial_number is a date in a format Excel recognises known as the date-time serial number.
Excel SECOND Function Examples
Tip: 0 is returned in cell C13 because there is no time portion to this date.
The SECOND function will also accept a text string, no need to convert the text to a date-time serial number first e.g. "4:15:58 AM"
You can also use the SECOND Function to populate the seconds argument of the TIME function e.g.
=TIME(0,0,SECOND(B10))
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.
Enter your email address below to download the sample workbook.
Download the Excel Workbook and PDF. Note: This is a zip file including an Excel workbook with detailed instructions and a PDF version for your reference.
Related Tutorials
| Excel TIME Function | Returns a time serial number, from separate hour, minute and second values |
| Excel HOUR Function | Returns the hour part of a time serial number |
| Excel MINUTE Function | Returns the minute part of a time serial number |
| Excel DATE Function | Returns a date in serial number from separate year, month and day values |
| Excel Time Calculation Tricks | Time and Date 101, plus common questions answered e.g. convert time to decimals, round time etc. |