HOUR

Gets the hour component of the specified date.

Syntax

=HOUR(date)

Arguments

Argument	Type	Description
date	Date	The date to use for calculation

Examples

=HOUR(DATE(2020, 2, 3, 4, 5))→4
Gets the hour component 4 from the specified date Feb 3, 2020 4:05 AM

=HOUR(DATE(2020, 4, 5, 6, 7))→6
Gets the hour component 6 from the specified date April 5, 2020 6:07 AM