How to Convert Decimal to Days Hours and Minutes in Excel (3 Methods)

While working with Microsoft Excel, sometimes we need to convert decimals to days, hours, and minutes. Converting decimals to days hours and minutes in Excel is an easy task. This is a time-saving task also. Today, in this article, we’ll learn three quick and suitable ways to convert decimal to days hours, and minutes in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Suitable Ways to Convert Decimal to Days Hours and Minutes in Excel

Let’s assume we have an Excel large worksheet that contains the information about several decimals. The decimals are given in Column B.  We will convert the decimal to days hours and minutes by using the TEXT, INT functions, and Custom Format. Here’s an overview of the dataset for today’s task.

convert decimal to days hours and minutes in excel


1. Use TEXT Function to Convert Decimal to Days Hours and Minutes in Excel

We will apply the TEXT function to convert decimals to days hours and minutes in Excel. This is an easy and time-saving task also. From our dataset, we will learn how to use the TEXT function to convert decimals to days hours, and minutes. Let’s follow the instructions below to convert decimals to days hours and minutes!

Step 1:

  • First of all, we will select a cell where we will apply the TEXT function. We select cell C5 for the convenience of our work.

Use TEXT Function to Convert Decimal to Days Hours and Minutes in Excel

  • Hence, write down the below TEXT function in that cell. The TEXT function in the formula bar is,
=TEXT(B5/24, " d\d h\h m\m")
  • Where B5/24 is the decimal value and “ d\d h\h m\m” is the format_text.

  • Further, simply press ENTER on your keyboard, and you will be able to convert 51 decimal values to 30d 3h 30m days, hours, and minutes by using the TEXT function.

Use TEXT Function to Convert Decimal to Days Hours and Minutes in Excel

Step 2:

  • After that, autoFill the TEXT function to the rest of the cells in column C which has been given in the below screenshot.

Read More: How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)


2. Combine INT and TEXT Functions to Convert Decimal to Days Hours and Minutes in Excel

In this method, we will not only use the INT function but also use the TEXT function to convert decimals to days hours, and minutes. Let’s follow the instructions below to convert decimals to days hours and minutes!

Step 1:

  • First, we will select cell C5.

Combine INT and TEXT Functions to Convert Decimal to Days Hours and Minutes in Excel

  • After that, type the below INT and TEXT functions in that cell. The INT and TEXT functions in the formula bar are,
=INT(B5/24) & "days   " & TEXT(B5/24, " h\h   m\m")

Formula Breakdown:

  • Inside the INT function, B5/24 is the decimal value and the INT function converts it into days.
  • Inside the TEXT function, B5/24 is the decimal value of the TEXT function and “ h\h m\m” is the format_text, and the TEXT function converts it into hours and minutes.

  • Hence, simply press ENTER on your keyboard.
  • As a result, you will be able to get 151days 3h 30m as the returns of the INT and the TEXT functions.

Combine INT and TEXT Functions to Convert Decimal to Days Hours and Minutes in Excel

Step 2:

  • Further, autoFill the INT and TEXT functions to the rest of the cells in column C which has been given in the below screenshot.

Combine INT and TEXT Functions to Convert Decimal to Days Hours and Minutes in Excel

Read More: How to Convert Hours and Minutes to Decimal in Excel (2 Cases)


Similar Readings


3. Apply Custom Format to Convert Decimal to Days Hours and Minutes in Excel

Last but not the least, we will apply the Custom Format command to convert decimals to days hours, and minutes in Excel. Let’s follow the instructions below to convert decimals to days hours and minutes!

Steps:

  • First, select the cell array from B5 to B14.
  • Then copy this array by using the keyboard shortcut Ctrl + C simultaneously.
  • After that, paste the copying cells array in column C by using the keyboard shortcut Ctrl + V simultaneously.

Apply Custom Format to Convert Decimal to Days Hours and Minutes in Excel

  • Hence, press Ctrl + 1 simultaneously on your keyboard.

  • As a result, a Format Cells dialog box will appear in front of you. From the Format Cells dialog box, firstly, select the Number Secondly, select the Custom command. Thirdly, type the h:mm in the typing box. At last press the OK option.

Apply Custom Format to Convert Decimal to Days Hours and Minutes in Excel

  • After completing the above process, you will be able to convert the decimals to days, hours, and minutes which has been given in the below screenshot.

Read More: How to Convert Hours to Decimal in Excel (3 Easy Methods)


Things to Remember

👉 You can press Ctrl  + 1 simultaneously on your keyboard to pop up the Format Cells dialog box.

👉 To copy data, you can press Ctrl + C simultaneously. To paste data, you can press Ctrl + V simultaneously on your keyboard.


Conclusion

I hope all of the suitable methods mentioned above to convert decimals to days hours and minutes will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo