Skip to content
Excel

HOUR function in Excel

Converts a serial number to an hour

=HOUR(serial_number)

HOUR syntax and parameters

One argument, one required.

  • serial_numberanyRequired

    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")).

HOUR examples

Formulas you'll actually reuse.

  1. The hour a shift ended, from a 17:15 clock-out time:

    =HOUR(C2)

    Result17

  2. Hours worked as a decimal — 08:30 to 17:15:

    =HOUR(C2 - B2) + MINUTE(C2 - B2) / 60

    Result8.75

HOUR in Google Sheets

Same name — your formula ports as-is.

Try HOUR in the playground

Edit the example — nothing to install.

Preloaded with the HOUR formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.