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.
How to Convert Days to Hours in Excel: 3 Easy Ways
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 Hours to Decimal in Excel
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
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: How to Convert Hours to Minutes in Excel
Practice Section
Now, you can practice the explained method by yourself.
Download Practice Workbook
You can download the practice workbook from here:
Conclusion
I hope you found this article helpful. Here, I have explained 3 suitable methods to convert Days to Hours in Excel. Please, drop comments, suggestions, or queries if you have any in the comment section below.
