Functions

HOUR

Hour component of a time serial number

Try it

When to use it

When should I use HOUR?

Use HOUR to extract the hour component (0–23) from a time serial number or time string, for example to classify events into morning, afternoon, or evening buckets.

Used in

operations

Syntax

HOUR(time)

Examples

=HOUR(TIME(11,40,59)) // => 11
=HOUR(40909.0004) // => 0
=HOUR("20:49:59") // => 20

HLOOKUP

Searches first row of range, returns value from index row

HSTACK

Horizontally stacks arrays