HOUR

Returns the hour of the serial number.

Syntax

=HOUR(DateValue, [Round])

Arguments

Name	Type	Description
DateValue	Number	A serial number 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.
Round (optional)	Boolean	Defines if value should be rounded. Default value: TRUE

Return

Type	Description
Number	Hour evaluated from serial number.

Examples

Formula	Result	Comment
=HOUR(43238.5)	12	The given date represents the 18th of May, 2018, 12:00
=HOUR(43930.999999, true)	0	Rounded to 0
=HOUR(43930.999999, false)	23	Same as before but prevent rounding