HOUR

Definition of HOUR

Returns the hour component of a specific time, in numeric format.

Sample Usage

HOUR(TIME(11,40,59))

HOUR(A2)

HOUR(40909.0004)

HOUR("20:49:59")

Syntax

HOUR(time)

• time - The time from which to calculate the hour component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

Notes

• Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as TIME, or a date serial number of the type returned by the N function.
• HOUR does not autoconvert number formats. Therefore, HOUR(12:00:00) will return an error.
• HOUR returns the intuitive understanding of hours, and is useful primarily in other calculations rather than to extract the hour component of a known time, as that value is easily known from a plain reading of the entire time.
• Note that date objects that are created with the DATE function or by entry of a date without a time component will have a time of 0:00:00.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

TIME: Converts a provided hour, minute, and second into a time.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the HOUR formula, start with your edited Excellentable

Then type in the HOUR Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14

	E	F	G
1

Date

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/9/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

7/8/2016 8:25

HOUR