Hour Function

Returns the hour from a time value that is generated by the TimeSerial or the TimeValue function.

Syntax:


Hour (Number)

Return values:

Integers

Parameter

Number: Numeric expression that contains the serial time value that is used to return the hour value.

This function is the opposite of the TimeSerial function. It returns an integer value that represents the hour from a time value that is generated by the TimeSerial or the TimeValue function. For example, the expression

Print Hour(TimeSerial(12:30:41))

returns the value 20.

Error codes:

5 Invalid procedure call

Example:


          Sub ExampleHour
          Print "The current hour is " & Hour( Now )
          End Sub
      

Please support us!