Souptik Roy
Sometimes. working in Excel, you may face the importance of Converting Decimal Time to Hours in Excel. But, converting Decimal Time to Hours in Excel is a very easy task. In this article, I will show you how to Convert Decimal Time to Hours in Excel. Moreover, I will describe the methods step by step with necessary pictures and illustrations. I hope you will be interested in this article and can enhance your Excel skills.
Download Practice Workbook
Please download the practice workbook to practice yourself.
3 Handy Approaches to Convert Time to Hours in Excel
Let’s consider a dataset of a trader. Here, the dataset has the Product Arrival Time. As you can see, the dataset has two columns B & C indicating Product & Arrival Time respectively. The dataset is ranging from B4 to C10.
1. Perform Arithmetic Calculation to Convert Time to Hours
In this portion of this article, I am going to describe how to Convert Time to Hours by performing Arithmetic Calculation step by step.
Steps:
- First, Select cell D5.
- After that, Write the following formula in D5:
=C5*24
- Then, Press the Enter button
- As a result, you will find the result in D5 just like the picture shown below.
- To change the number format, Go to the Home tab first.
- After that, Select the Number
- Then Select the dropdown bar.
- Hence, Select the General option.
- As a result, you will find the result in D5 just like the picture given below.
- After that, Fill Handle the formula from D5 to D10.
- At last, you will find the result just like the picture given below.
Read More: Convert Time to Minutes in Excel (5 Suitable Methods)
2. Apply CONVERT Function to Convert Time to Hours in Excel
In this part, I will show Excel’s steps to Convert Time to Hours by applying CONVERT Function. Here I am going to show the steps with necessary illustrations.
Steps:
- First, Select the D5 cell
- Then, Write down the following formula in the D5 cell:
=CONVERT(C5, "day", "hr")- Press Enter.
- You will find the result just like the picture given below.
- Then, Fill Handle the formula from D5 to D10.
- As a result, you will get the values just like the one given below.
Read More: How to Convert Days to Hours in Excel (3 Easy Ways)
Similar Readings
- How to Convert Hours to Percentage in Excel (3 Easy Methods)
- How to Convert Minutes to Days in Excel (3 Easy Methods)
- Convert Time to Text in Excel (3 Effective Methods)
- How to Convert Minutes to Hundredths in Excel (3 Easy Ways)
- How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)
3. Convert Time to Hours by Combining HOUR, MINUTE, & SECOND Functions
Now, I am going to describe another new method to Convert Time to Hours in Excel. Here I will use HOUR, MINUTE, & SECOND Functions in this method. Let’s see the method step by step with the necessary pictures.
Steps:
- In the very first step, Select the D5
- Then, Write down the formula following formula in the D5 cell:
=HOUR(C5)+MINUTE(C5)/60+SECOND(C5)/3600- Press Enter.
- Hence, you will find the result just like the picture given below.
- Then, Fill Handle the formula from D5 to D10.
- At the last point, you will get the values just like the one given below.
Read More: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
Convert Decimal Time to Hours and Minutes in Excel
Here, I will show you how to Convert Decimal Time to Hours and Minutes in Excel. These steps are quite similar to the methods mentioned earlier. I will consider the same dataset. For this method, we are considering the Product Arrival time in Decimal. I will apply the TEXT Function to Convert Decimal Time to Hours and Minutes in Excel.
Steps:Â
- First, Select the D5 cell.
- In that cell, Insert the following formula,
=TEXT(C5/24,"h:mm")- Press the Enter
- You will find the result just like the picture given below.
- After that, Fill Handle the formula from D5 to D10.
- As a result, you will find the converted time just like the picture given below.
Read More: Convert Decimal Coordinates to Degrees Minutes Seconds in Excel
Things to Remember
- For every method, after applying formula, if the result is in Custom number format, you will need to change the format to General to get the shown result.
Conclusion
I hope this article will help you to Convert Time to Hours in Excel. If you have any kind of queries, feel free to ask me in the comment section or just have a look at our website Exceldemy.com.
Related Articles
- How to Convert Hours to Minutes in Excel (3 Easy Ways)
- Convert Military Time to Standard Time in Excel (2 Suitable Ways)
- How to Convert Time to Decimal in Excel (3 Quick Ways)
- Convert Epoch Time to Date in Excel (2 Easy Methods)
- How to Convert Minutes to Seconds in Excel (2 Quick Ways)
- How to Convert Hours to Days in Excel (6 Effective Methods)
