Better Sheets

How to Use HOUR() in Google Sheets

Description

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

How To Actually Use HOUR() in Sheets

HOUR(time)

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.

Your formula

Hints (2)

Locale Separator ,

Better Sheets Tutorial

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

Transcript-matched member videos for HOUR(). Click through to watch.

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

I'll show you how to create a visual clock in your Google Sheet using co...

Intermediate

NOW() TIMEVALUE()

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

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.

More related tutorials