Extract the hour from a time.

`HOUR(serial_number)`

- serial_number - required argument for specifying the time

`=HOUR("4:30 PM")`

The HOUR function returns the hour number of a time value. This example returns 16.

`=HOUR(A1)`

The HOUR function can also be used to return the hour number from a cell that contains a time value. If cell A1 contains the time value "4:30 PM", will also return 16.

`=HOUR("23:59")`

The HOUR function will return a number between 0 and 23, depending on the time you specify, and will return 23.

`=HOUR("1/1/2020 4:30 PM")`

The HOUR function can also be used to return the hour number from a date and time value, and will return 16.

`=HOUR(A1)`

The HOUR function can also be used to return the hour number from a cell that contains a date and time value. If cell A1 contains the date and time value "1/1/2020 4:30 PM", then will also return 16.

The HOUR function is used to return the hour of a time value as an integer. It takes a time value as a decimal number, which can be a text string, decimal number, or formula/function result.

- The HOUR function takes one argument - serial_number - and returns a number between 0 and 23 as the hour from a time zone.
- The HOUR function resets every 24 hours and works with hour values larger than 24 using a formula to convert time to decimal hours.

The HOUR function returns the hour of a time value as a number. The hour is an integer, which represents the hour from 0 to 23.

Times can be entered as text strings within quotation marks. The text strings may also be entered as decimal numbers. The HOUR function takes a time value as a decimal number.

The HOUR function returns an integer, which represents the hour from 0 to 23.

Yes, times can be entered as text strings within quotation marks.

Drop CSV