HOUR function - The function converts a serial number into an hour in Excel

The following article details how to use the HOUR function, the function converts a serial number into an hour.

Description: The function returns the hour value in time, hour, second, or date value that contains the hour.

Syntax : HOUR (Serial-number) .

Inside:

Serial-number : This is the time value that you want to get separate time value, is a required parameter.

For example:

Count the hours in the following time values:

HOUR function - The function converts a serial number into an hour in Excel Picture 1

To calculate the time value 8:45:25 enter the formula: = HOUR (D6) .

HOUR function - The function converts a serial number into an hour in Excel Picture 2

Pressing Enter results time it is 8 hours. Because that time is not specified as AM or PM, the function returns the time value by default based on the initial time to be calculated.

HOUR function - The function converts a serial number into an hour in Excel Picture 3

Similarly, the date time value containing the hour and the time value converted to decimal are calculated using the HOUR function .

HOUR function - The function converts a serial number into an hour in Excel Picture 4

The above is how to use as well as the case to use the HOUR function .

Good luck!

4 ★ | 1 Vote

May be interested

  • Instructions on how to find serial numbers of Windows computersInstructions on how to find serial numbers of Windows computers
    just like the imei number on mobile devices, serial numbers are important information for each computer. when you need to install the driver or provide the necessary information to the support staff when using the warranty service, the user needs to provide the serial number of the machine.
  • 4 ways to fix IDM error Fake Serial Number4 ways to fix IDM error Fake Serial Number
    not free as other download accelerators, idm only allows users to use for 30 days. however, there are still pirated versions with fake license keys, and when users use them, internet download manager will report internet download manager errors that have been registered with a fake serial number or serial number has been blocked.
  • How to check the serial number of AirPods ProHow to check the serial number of AirPods Pro
    the serial number on airpods pro is essential for device warranty.
  • Round function, how to use rounded functions in ExcelRound function, how to use rounded functions in Excel
    the round function in excel will help the user round the number to a number of predefined words, making the worksheet more scientific.
  • Round a number in Excel (ROUND function)Round a number in Excel (ROUND function)
    instructions on how to round numbers in excel, help calculate faster depending on how to round the number of digits after and before the comma, there are many number rounded functions in excel. 1. round a number using the round () function - meaning: rounds to the nearest number
  • How to Convert Time from 24-Hour to 12-HourHow to Convert Time from 24-Hour to 12-Hour
    if you're confused when you see a clock displaying the time in a format like 14:24, you're probably not familiar with 24-hour time. this convention is often used in the us military, in europe and many other parts of the world. fortunately, converting time from 24-hour to 12-hour (or standard) and vice versa is very simple. you just need to convert the hours, and keep the minutes the same.
  • Instructions on how to find the serial number of the MacInstructions on how to find the serial number of the Mac
    each mac has its own serial number to distinguish between different machines. when bringing the device to a service center, we also need to provide the exact serial number of the mac.
  • How to Find Your MacBook's Serial NumberHow to Find Your MacBook's Serial Number
    need to inventory your macbook? to do that, you probably want its serial number. click the apple menu on the far left of your screen and select 'about this mac'.
  • How to fix the SUM function doesn't add up in ExcelHow to fix the SUM function doesn't add up in Excel
    in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?
  • How to Convert Measurements Easily in Microsoft ExcelHow to Convert Measurements Easily in Microsoft Excel
    excel's convert function ('=convert()') converts a measurement from one unit to another. to use this function, you will enter data and units into the formula: =convert(number, 'from_unit', 'to_unit'). first learn how to enter the convert...