Returns a Variant (Integer) specifying a whole number between 0 and 23, inclusive, representing the hour of the day.
This example uses the Hour function to obtain the hour 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, MyHour MyTime = #4:35:17 PM# ' Assign a time. MyHour = Hour(MyTime) ' MyHour contains 16.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.