How to Convert Days to Hours in Excel (3 Easy Ways)

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.

Dataset of How to Convert Days to Hours in Excel


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.

Use of CONVERT Function for Converting Days to Hours in Excel

  • 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*24

In 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.

Applying Generic Formula to Convert Days to Hours in Excel

  • 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


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.

Employing TEXT Function to Convert Days to Hours

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

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo