Excel HOUR Function returns the hour portion of a time value. It’s a simple function that can be useful in various scenarios, like tracking working hours or analyzing time-related data.

## Syntax

**HOUR(serial_number)**

## Arguments

serial_number | The time value from which you want to extract the hour. |

## How to Use

The HOUR function is straightforward to use. You provide a time value as the argument, and it returns the hour as an integer. Here’s how you can use it with some examples:

Let’s assume you have a time value in cell A1, which is 3:45 PM (15:45 in 24-hour format). To extract the hour, you can use the following formula:

1 |
=HOUR(A1) |

This formula will return 15 since 3:45 PM corresponds to the 15th hour of the day.

Here are a few more examples:

1 |
=HOUR("8:30 AM") |

This formula returns 8 because it’s 8:30 in the morning.

1 |
=HOUR("22:15") |

This formula returns 22 as it’s 10:15 PM in the 24-hour format.

If you want to extract the hour from a specific time within a date and time value, you can do so as well:

1 |
=HOUR("2023-11-03 14:30:00") |

This formula extracts the hour from the given date and time, resulting in 14.

## Additional Information

The HOUR function can be particularly useful when working with datasets that involve time tracking, scheduling, or other time-related analysis. It helps you isolate the hour component of a time value, making it easier to perform calculations or create visualizations based on time data.