Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.

Dataset for convert minutes to days in excel

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.

Manually convert minutes to days in excel

Read More: How to Convert Hours to Days in Excel (6 Effective Methods)


Similar Readings


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")

CONVERT function to convert minutes to days in excel

  • Then, press ENTER. Excel will return the output.

  • After that, use Fill Handle to AutoFill up to C14.

CONVERT function to convert minutes to days in excel

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"

Combination to convert minutes to days in excel

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.

Combination to convert minutes to days in excel

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

Akib

Akib

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

Leave a reply

ExcelDemy
Logo