Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. While working in Excel, we often need to convert units. This is very easy in Excel. For example, we can easily convert minutes to days in Excel. In this article, I will show 3 easy ways to convert minutes to days in Excel.
How to Convert Minutes to Days in Excel: 3 Easy Methods
This is the dataset for today’s article. We have some minutes which we will convert to days.
Let’s see how these methods work one by one.
1. Convert Minutes to Days Manually in Excel
First of all, I will show how to convert minutes to days manually in Excel. For this method, I will use some relations between the time units.
1 day = 24 hour = (24*60) or 1440 minutes
Now, let’s convert minutes step by step.
Steps:
- Go to C5 and write down the formula
=B5/1440
- Then press ENTER to get the output.
- After that, use Fill Handle to AutoFill up to C14.
Read More: How to Convert Seconds to Hours and Minutes in Excel
2. Use CONVERT Function to Convert Minutes to Days in Excel
Now, I will use the CONVERT function to convert minutes to days. This function converts numbers from one unit to another.
Steps:
- Go to C5 and write down the formula
=CONVERT(B5,"mn","day")
- Then, press ENTER. Excel will return the output.
- After that, use Fill Handle to AutoFill up to C14.
Note: When writing the CONVERT function, Excel offers a list of units. You can choose from there or write down the units by yourself.
Read More: How to Convert Minutes to Decimal in ExcelÂ
3. Combination of INT and MOD Functions to Convert Minutes
In this section, I will show how you can convert minutes to days, hours, and minutes in Excel. This time, I will use a combination of the INT, ROUND, and MOD functions. Let’s do it step by step.
Steps:
- Go to C5 and write down the following formula
=INT(B5/1440)&" days "&INT(MOD(B5/1440,1)*24)&" hours "&ROUND(MOD(MOD(B5/1440,1)*24,1)*60,0)&" minutes"
Formula Breakdown
- MOD(B5/1440,1) → This will return the remainder after dividing 47/1440 by 1.
- Output: 0.0326388888888889
Â
- MOD(B5/1440,1)*24
- Output: 0.783333333333333
Â
- MOD(MOD(B5/1440,1)*24,1)*60 → This part becomes,
- MOD(0.783333333333333,1)*60
- Output: 47
Â
- ROUND(MOD(MOD(B5/1440,1)*24,1)*60,0) → The ROUND function rounds a number to a specific digit. This part becomes,
- ROUND(47,0)
- Output: 47
Â
- INT(MOD(B5/1440,1)*24)
- Output: 0
Â
- INT(B5/1440)
- Output: 0
Â
- =INT(B5/1440)&” days “&INT(MOD(B5/1440,1)*24)&” hours “&ROUND(MOD(MOD(B5/1440,1)*24,1)*60,0)&” minutes” → The final formula reduces to,
- 0&” days “&0&” hours “&47&” minutes”
- Output: 0 days 0 hours 47 minutes
- Now, press ENTER to get the output.
- Finally, use Fill Handle to AutoFill up to C14.
Read More: How to Convert Minutes to Hours and Minutes in Excel
Things to Remember
- Ampersand (&) joins texts in Excel.
Download Practice Workbook
Download this workbook and practice while going through the article.
Conclusion
In this article, I have explained 3 methods to convert minutes to days in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.
Related Articles
- Excel Convert Seconds to hh mm ss
- How to Convert Minutes to Seconds in Excel
- How to Convert Minutes to Hundredths in Excel
- How to Convert Minutes to Tenths of an Hour in Excel
- How to Convert Seconds to Minutes in Excel
- How to Convert Milliseconds to Seconds in Excel
- How to Convert Seconds to Hours Minutes Seconds in Excel
<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!