HOUR Function in Google Sheets

Extract the hour from a given time using the HOUR function.

HOUR Function

The HOUR function in Google Sheets extracts the hour from a given time.

Syntax

HOUR(time)
  • time: The time from which to extract the hour.

Examples

  1. Extract Hour from Time

Extract the hour from 13:45:30:

=HOUR("13:45:30")
  1. Extract Hour from Current Time

Extract the hour from the current time:

=HOUR(NOW())

Notes

  • Returns an integer between 0 and 23.
  • Supports different time formats, including date-time combinations.
  • MINUTE: Extracts the minute from a time.
  • SECOND: Extracts the second from a time.