Second
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the second of the minute.
Syntax: Second ( time )
- time
- required Any Variant, numeric expression, string expression, or any combination that can represent a time. If time contains Null, Null is returned.
Common Errors
| Error | When |
|---|---|
13 (&HD), Type mismatch | time is a string that is not a time, a number outside the range of dates, or an Error value |
Example
This example uses the Second function to obtain the second of the minute from a specified time.
Dim MyTime, MySecond
MyTime = #4:35:17 PM# ' Assign a time.
MySecond = Second(MyTime) ' MySecond contains 17.