Formulas > =HOUR()
How to Use HOUR() in Google Sheets
Description
How To Actually Use HOUR() in Sheets
HOUR(time)
Try HOUR yourself
In cells B1:B10, enter various time values. In cells C1:C10, create a formula that extracts the hour from the corresponding time in column B.
Hints (2)
-
Make sure to reference the correct cell in column B.
-
The HOUR function only requires one argument.
1 Better Sheets Tutorial
Building a Year Progress Clone
Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.
EOMONTH()
HOUR()
MONTH()
NOW()
SPARKLINE()
+3 more
Learn more about the HOUR() formula:
Generate a HOUR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses HOUR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a HOUR() formula