SECOND
Syntax:
SECOND ( time-value )
Description: Computes the second for the date and/or time having the given time-value.
Arguments:
Name |
Type |
Description |
|---|---|---|
time-value |
number |
The date and/or time whose second is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its integer part is ignored, or as a string-constant having any valid date and/or time format, in which case, any date information shall be ignored. |
Return Type and Value: number – The second for the date and/or time having the given time-value.
However, if time-value is out of range for the current date base value, #NUM! is returned.
example: