Navigation:  Formulas and functions > Functions from A to Z > HOUR (hour)

Syntax:

HOUR(Time)

Description:

This returns the hour of a time value.

Example:

HOUR("12:34:56 AM") returns 12

HOUR("09/25/2018 10:30:56") returns 10

If cell A1 contains a date with the time 10:30:56, then HOUR(A1) returns 10

See also:

MINUTE, SECOND, MILLISECONDS