Skip to main content
Version: Streamsheets 2.5

HOUR

Returns the hour of the serial number.

Syntax

=HOUR(DateValue, [Round])

Arguments

NameTypeDescription
DateValueNUmberA 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)BooleanDefines if value should be rounded. Default is true.

Return

Hour evaluated from serial number.

Examples

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