Hour function

Category: Date & Time

Summary

Hour (0–23).

Syntax

Hour(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 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.

Microsoft Support Page

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

Back to Functions