Second function

Category: Date & Time

Summary

Seconds (0–59).

Syntax

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.

Example

Example
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.

Microsoft Support Page

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/second-function

Back to Functions