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




serial_number – (required) The time that contains the second you want to extract.

SECOND Function Usage Examples:

Let’s look at the following example that shows how the second is removed from a time value in Excel.

SECOND Function

Here are some other usage examples. Excel ignores hours, minutes, and dates when using the SECOND function. Decimal numbers, such as .258, are treated as a % of 24 hours. For example, Excel calculates .258% of 24 hours and returns 31.

SECOND Function usage Examples

Usage Errors

#VALUE! error – The serial_number is not a valid Excel time.

Leave a Reply

PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate.

Read More »


The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically

Read More »
Scroll to Top