MS Excel: Hour Function

In Excel, the Hour function returns the hour of a time value (from 0 to 23).

The syntax for the Hour function is:

Hour( serial_number )

serial_number is the time value to extract the hour from. It may be expressed as a string value, a decimal number, or the result of a formula.

Applies To:

For example:

Let's take a look at an example:

Based on the spreadsheet above, the function would return the following values:

=Hour(A1) would return 22

=Hour(A2) would return 7

=Hour("4:30:00 AM") would return 4

=Hour("4:30:00 PM") would return 16

VBA Code

The Hour function can also be used in VBA code. For example:

Dim LHour As Integer

LHour = Hour("10:42:58 PM")

In this example, the variable called LHour would now contain the value of 22.