Table of Contents
The HOUR function in Excel is a useful tool for extracting the hour from a given time. It allows users to easily retrieve the hour portion of a specific time, which can be helpful in various data analysis and calculations. By using the HOUR function, users can save time and effort in manually converting time formats and accurately obtain the hour value they need. This function is especially beneficial for individuals working with large amounts of time data in spreadsheets, as it provides a quick and efficient way to manipulate time values.
This article describes the formula syntax and usage of the HOUR function in Microsoft Excel.
Description
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.).
Syntax
HOUR(serial_number)
The HOUR function syntax has the following arguments:
Serial_number 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”)).
Remark
Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).
Cite this article
stats writer (2024). “How can I use the HOUR function in Excel to extract the hour from a given time?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-hour-function-in-excel-to-extract-the-hour-from-a-given-time/
stats writer. "“How can I use the HOUR function in Excel to extract the hour from a given time?”." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-hour-function-in-excel-to-extract-the-hour-from-a-given-time/.
stats writer. "“How can I use the HOUR function in Excel to extract the hour from a given time?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-hour-function-in-excel-to-extract-the-hour-from-a-given-time/.
stats writer (2024) '“How can I use the HOUR function in Excel to extract the hour from a given time?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-hour-function-in-excel-to-extract-the-hour-from-a-given-time/.
[1] stats writer, "“How can I use the HOUR function in Excel to extract the hour from a given time?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How can I use the HOUR function in Excel to extract the hour from a given time?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.