The Excel Second function returns an integer representing the second component of a supplied Excel time.
The syntax of the function is:
where the serial_number argument is the time from which you want to extract the second 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.
Four examples of the Excel Second function are shown in column B of the following spreadsheet.
|
Formulas:
|
Results:
|
For further information and examples of the Excel Second function, see the Microsoft Office website.
If you get an error from the Excel Second Function, this is likely to be the #VALUE! error:
| #VALUE! | - | Occurs if the supplied serial_number is not a valid Excel time. |