Hour

Calculates the hour value from the given time argument passed to the function.

Syntax

Hour(Time)

Time:

A string or expression that can represent a time value. This includes and combination of time literals, numbers that look like times, strings that look like times, and times from functions.

Return Value

Returns an integer between 0 and 23 that is the hour of the parameter (Time).

Related Functions

Minute | Second

Example

Dim varMyHour, varMyTime

varMyTime = "08:04:23 PM"

varMyHour = Hour(varMyTime)

' stores hours value.