Md. Abdur Rahim Rasel
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.
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 (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.
- 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.
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.
Read More: How to Convert Hours and Minutes to Decimal in Excel (2 Cases)
Similar Readings
- How to Fix Decimal Places in Excel (7 Simple Ways)
- Insert Dot between Numbers in Excel (3 Ways)
- How to Remove Decimal Places in Excel (5 Easy Methods)
- Reduce Decimals in Excel (10 Easy Methods)
- How to Set Decimal Places in Excel with Formula (5 Effective Ways)
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 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
- How to Remove Decimals in Excel with Rounding (10 Easy Methods)
- Converting Time to Decimals in Excel (4 Examples)
- How to Remove Decimals without Rounding in Excel (4 Suitable Ways)
- Excel 2 Decimal Places without Rounding (4 Efficient Ways)
- How to Convert Minutes to Decimal in Excel (3 Quick Ways)
- Change Decimals to Percentages in Excel (4 Easy Ways)
