• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

HOUR in Excel

September 1, 2021 by Andrew Childress
Hour in Excel

As you work in Excel, you may find yourself using time units. These include hours, minutes, seconds, and more. Here's how to use HOUR in Excel.

As you work in Excel, you may find yourself using time units. These include hours, minutes, seconds, and more. It’s often useful to display an hour value in a cell of its own. Fortunately, this is very easy to do in Excel. Let’s learn how to use HOUR in Microsoft Excel.

How to Use HOUR in Excel

Consider a list of times: 12:30, 9:33, 18:55, and so on. These are simple hour-and-minute times that you may encounter when you work with your data. It’s helpful to have the hour values listed separately, especially if you are performing calculations like finding the average hour, for example.

Of course, you could list the hours in their own cells by typing them in manually. But this is repetitive, and would take far too long if you had a lengthy list of times. This is where Excel’s HOUR function comes in.

To use HOUR, click into any empty cell in your workbook. It’s worth noting here that HOUR is based on 24-hour times. In other words, typing 6:35 will be treated as 6:35 AM. To type 6:35 PM, you should use 18:35. 

In the cell you’ve selected, type an = sign, followed by HOUR(. Your formula reads:

=HOUR(

Hour Excel

Then, click into the cell containing a time that you want to extract the hour from. Here, we’ll use cell A1. Lastly, close the parentheses, completing your formula as follows:

=HOUR(A1)

Hour in Excel

Hit Enter on your keyboard, and Excel displays the hour value: 12. From here, you can click and drag downward to copy your formula over the other times listed.

Hour function Excel

As you can see, Excel’s HOUR function makes it easy to extract the hour from a given time input. It’s easy to use, and fast to copy across large volumes of data. This streamlines your analysis tasks and makes your data more useful to you.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Year formula Excel YEAR in Excel
Next Post: Rearrange the Ribbon in Excel How to rearrange ribbon in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top