HOURΒΆ

Returns the hour of the date value.

Syntax

=HOUR(time)

Arguments

Name

Description

time

Insert a valid timestamp format or a cell referenz to a timestamp. A timestamp consists out of two numbers. The number to the left of the decimal define the days since 01.01.1900. The number to the right of the decimal define the fraction of the day.

Return Value

Hour evaluated from date value.

Example

Function

Result

Comment

=HOUR(43238.5)

12

The given date value represents the 18th of May, 2018, 12:00