Musiha Mahfuza Mukta
If you need to convert Days to Hours in Excel then you have come to the right place. In this article, I will explain how to convert Days to Hours in Excel. Furthermore, I will show you the detailed process.
Download Practice Workbook
You can download the practice workbook from here:
3 Methods to Convert Days to Hours in Excel
Here, I will demonstrate 3 quick and easiest methods to convert Days to Hours in Excel. For your better understanding, I will use a sample dataset. Which has 4 columns. They are Product, Order Date, Delivery Date, and Duration. The dataset is given below.
1. Use of CONVERT Function for Converting Days to Hours
Here, you can use the CONVERT function to get the Days into Hours. This is the easiest way for different types of conversion. Moreover, there are lots of built-in terms for Unit conversion which are given in Excel. Now, talking about the conversion of Days to Hours. The steps are given below.
Steps:
- Firstly, you have to select a new cell F5 where you want to see the Duration in Hours.
- Secondly, you should use the formula given below in the F5 cell.
=CONVERT(E5,"day","hr")In this formula, the CONVERT function will convert E5 cell values from Day unit to Hour unit.
- Subsequently, press ENTER to get the result.
- Now, I will copy the same formula using relative cell references. To do this, select cell F5. A square box will be shown in the bottom-right corner of cell F5, it is called the Fill Handle icon. Click the Fill Handle icon, hold it, and drag until you reach cell F11.
- Then, release the Mouse cursor.
Lastly, you will get all the converted hours.
Read More: How to Convert Time to Hours in Excel (3 Easy Methods)
2. Applying Generic Formula to Convert Days to Hours in Excel
As well as, you can apply a simple formula without the help of any Excel function to convert Days to Hours. The steps are given below.
Steps:
- Firstly, you have to select a new cell F5 where you want to see the Duration in Hours.
- Secondly, you should use the formula given below in the F5 cell.
=E5*24In this formula, I have multiplied the E5 cell value with 24. Because, you know that 1 day is equal to 24 hours.
- Finally, press ENTER to get the result.
- After that, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells F5:F11. Or you can double-click on the Fill Handle icon.
Finally, you will get all the converted Hours.
Read More: How to Convert Hours to Days in Excel (6 Effective Methods)
Similar Readings
- How to Convert Minutes to Hours and Minutes in Excel
- Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
- Excel Convert Seconds to hh mm ss (7 Easy Ways)
- Convert Decimal Coordinates to Degrees Minutes Seconds in Excel
- Convert Epoch Time to Date in Excel (2 Easy Methods)
3. Employing TEXT Function to Convert Days to Hours in Excel
Furthermore, you can employ the TEXT function to convert Days to Hours in Excel. In this method, I will also show you how to add the word “Hours” beside the converted hours. The steps are given below.
Steps:
- Firstly, you have to select a new cell F5 where you want to see the Duration in Hours.
- Secondly, you should use the formula given below in the F5 cell.
=TEXT(E5,"[h]") & " Hours"- Finally, press ENTER to get the result.
Formula Breakdown
Here, the TEXT function will format any text with a given formatting.
- Firstly, E5 is the cell value. The TEXT function will format this cell value.
- Secondly, “[hr]” denotes the value that should be converted into hours.
- Thirdly, ” Hours” denotes hours as a text. Here, if you notice then you will see there is additional space before the Hours text. This is because I want to keep some space between the value and unit name.
- Finally, the Ampersand (&) operator will join the output and Hours together.
- After that, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells F5:F11. Or you can double-click on the Fill Handle icon.
Finally, you will get all the converted Hours.
Read More: Convert Time to Text in Excel (3 Effective Methods)
Practice Section
Now, you can practice the explained method by yourself.
Conclusion
I hope you found this article helpful. Here, I have explained 3 suitable methods to convert Days to Hours in Excel. Also, you can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Convert Hours to Percentage in Excel (3 Easy Methods)
- Convert Minutes to Days in Excel (3 Easy Methods)
- How to Convert Minutes to Hundredths in Excel (3 Easy Ways)
- Convert Seconds to Hours Minutes Seconds in Excel
- How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)
- How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
