The VBA HOUR Function


The VBA Hour Function returns the hour component of a supplied time. The syntax of the function is:

Hour( time )

VBA Hour Function Example

A simple example of the VBA Hour function is shown below:

Const CurrTime = "17:56:33"
Dim HourNum As Integer

HourNum = Hour(CurrTime)

After running the above snippet of VBA code, the variable 'HourNum' holds the value 17, which is the hour component of the supplied time "17:56:33".

Return to the VBA Operators & Functions Page

Return to the Excel VBA Tutorial Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2015