Home › Functions › Date & Time › =HOUR()
Date & Time All versions ◉ 26 views

=HOUR()

Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=HOUR(serial_number)
Hover argument names in the table for details.
Output typeNumber
Popularity35 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =HOUR() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download HOUR.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
serial_number Date Required The time that contains the hour you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

▣ Examples

▦ Data
CellValue
A2 Time
A3 0.75
A4 7/18/2011 7:45
A5 4/21/2012
A6 Time
A7 0.75
A8 7/18/2011 7:45
A9 4/21/2012
Returns 75% of 24 hours =HOUR(A2)
Result: 18
Returns the hour portion of the date/time value. =HOUR(A3)
Result: 7
A date with no time portion specified is considered 12:00 AM, or 0 hours. =HOUR(A4)
Result: 0

⇄ Related Functions

=NOW() Returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet. =MINUTE() Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59. =SECOND() Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. =TIME() Returns the decimal number for a particular time. If the cell format was General before the function was entered, the result is formatted as a date. The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.