{"id":1288,"date":"2018-07-02T17:39:09","date_gmt":"2018-07-02T17:39:09","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1288"},"modified":"2023-11-03T09:08:04","modified_gmt":"2023-11-03T09:08:04","slug":"hour","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/hour\/","title":{"rendered":"HOUR function"},"content":{"rendered":"\n
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.<\/p>\n\n\n\n
HOUR(serial_number)<\/strong><\/p>\n\n\n\n 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:<\/p>\n\n\n\n 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:<\/p>\n\n\n\n This formula will return 15 since 3:45 PM corresponds to the 15th hour of the day.<\/p>\n\n\n\n Here are a few more examples:<\/p>\n\n\n\n This formula returns 8 because it’s 8:30 in the morning.<\/p>\n\n\n\n This formula returns 22 as it’s 10:15 PM in the 24-hour format.<\/p>\n\n\n\n If you want to extract the hour from a specific time within a date and time value, you can do so as well:<\/p>\n\n\n\n This formula extracts the hour from the given date and time, resulting in 14.<\/p>\n\n\n\n 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.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel HOUR Function returns the hour portion of a time value. It’s a simple function that can be useful in various scenarios, like…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
serial_number<\/strong><\/td> The time value from which you want to extract the hour.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=HOUR(A1)<\/code><\/pre>\n\n\n\n
=HOUR(\"8:30 AM\")<\/code><\/pre>\n\n\n\n
=HOUR(\"22:15\")<\/code><\/pre>\n\n\n\n
=HOUR(\"2023-11-03 14:30:00\")<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n