title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
---|---|---|---|---|---|---|
Second function (Visual Basic for Applications) |
vblr6.chm1009011 |
|
fef87486-ccda-23e7-04a5-5e484ce66543 |
12/13/2018 |
medium |
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the second of the minute.
Second(time)
The required time argument is any Variant, numeric expression, string expression, or any combination, that can represent a time. If time contains Null, Null is returned.
This example uses the Second function to obtain the second of the minute from a specified time. In the development environment, the time literal is displayed in short time format by using the locale settings of your code.
Dim MyTime, MySecond
MyTime = #4:35:17 PM# ' Assign a time.
MySecond = Second(MyTime) ' MySecond contains 17.
[!includeSupport and feedback]