# How to Convert Minutes to Days in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

## 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 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.  ### 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. ### 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)*60This 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. ## 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 #### Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  