The Excel SECOND function returns the second integer from a time serial number ranging from 0 to 59.
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.
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.
|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.|