MS Excel: Second Function
In Excel, the Second function returns the second of a time value (from 0 to 59).
The syntax for the Second function is:
Second( serial_number )
serial_number is the time value to extract the second from. It may be expressed as a string value, a decimal number, or the result of a formula.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the spreadsheet above, the function would return the following values:
=Second(A1) would return 35 =Second(A2) would return 0 =Second("4:00:03 AM") would return 3 =Second("4:30:24 AM") would return 24