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. We’ll use Excel’s built-in functions, such as the TEXT and INT functions, and custom formatting cells, to convert decimal to days hours, and minutes.
How to Convert Decimal to Days Hours and Minutes in Excel: 3 Suitable Ways
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.
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.
- 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.
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
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.
- 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 TEXT functions.
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.
Similar Readings
- Convert Number to Hours and Minutes in Excel
- How to Convert Number to Minutes in Excel
- How to Convert Fraction into Hours and Minutes in Excel
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.
- 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.
- 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 Decimal to Time Over 24 Hours in Excel
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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.