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.


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.

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

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

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

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.

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


<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo