Akib Bin Rashid
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.
Download Practice Workbook
Download this workbook and practice while going through the article.
3 Easy Ways to Convert Minutes to Days in Excel
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 minutesNow, 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 Hours to Days in Excel (6 Effective Methods)
Similar Readings
- Convert Time to Text in Excel (3 Effective Methods)
- How to Convert Seconds to Hours Minutes Seconds in Excel
- Convert Minutes to Hundredths in Excel (3 Easy Ways)
- How to Convert Hours to Percentage in Excel (3 Easy Methods)
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 Seconds in Excel (2 Quick Ways)
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.
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. Please visit Exceldemy for more useful articles like this.
Related Articles
- Convert Decimal Coordinates to Degrees Minutes Seconds in Excel
- Excel Convert Seconds to hh mm ss (7 Easy Ways)
- How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
- Convert Seconds to Minutes in Excel
- How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)
- Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
