Learn how to convert minutes into hours using Excel with these easy-to-follow steps. This guide will teach you how to convert minutes into decimal hours or regular hours and minutes format. Excel, minutes, hours, convert, decimal, format, formula, calculation
How to Calculate Minutes into Hours in Excel
If you need to convert minutes into hours in Excel, you’re in luck. Excel makes it easy to perform this conversion with just a few simple steps. In this guide, we’ll show you how to convert minutes into decimal hours or regular hours and minutes format.
Getting Started
To get started, open an Excel spreadsheet and enter the minutes you want to convert into a cell. For this example, we’ll use the value 120.
Next, create a new cell where you want the result to appear. This is where you’ll enter the formula to convert the minutes into hours.
Converting Minutes into Decimal Hours
To convert minutes into decimal hours, divide the minutes by 60. For example, if you want to convert 120 minutes into decimal hours, enter =120/60 in the new cell.
Press enter to see the result in decimal format. In our example, 120 minutes would be equal to 2 hours.
Converting Minutes into Regular Hours and Minutes Format
To convert minutes into regular hours and minutes format, use the following formula: =INT(A1/60)":"&ROUNDUP(MOD(A1,60),0).
In the formula, replace A1 with the cell containing the minutes you want to convert. The INT function rounds down the result of the division to get the number of hours. The ":" symbol adds the colon between hours and minutes. The MOD function calculates the remainder when the minutes are divided by 60. The ROUNDUP function rounds up the result of the MOD function to the nearest whole number.
Press enter to see the result in regular hours and minutes format. In our example, 120 minutes would be equal to 2:00.
Adding a Label to the Result Cell
You can also add a label to the result cell to indicate whether the value is in decimal or regular hours and minutes format.
To add a label, right-click on the cell and select "format cells." In the format cells dialog box, select the Number tab. Under Category, select "Custom." Under Type, enter the code "[h]:mm" for regular hours and minutes format, or "0.00" for decimal format. Click OK to apply the formatting.
Your result cell will now display the converted value with your chosen formatting.
Converting Larger Numbers of Minutes
You can also use the same formulas to convert larger numbers of minutes by simply replacing the cell reference in the formula. For example, if you wanted to convert 720 minutes into hours, you would use the formula =INT(A1/60)":"&ROUNDUP(MOD(A1,60),0) and replace A1 with 720.
Excel makes it easy to convert minutes into hours in just a few simple steps. With these easy-to-follow instructions, you’ll be able to convert minutes into decimal or regular hours and minutes format quickly and easily.
Remember to format your result cell appropriately to display your conversion in the desired format. With a little practice, you’ll be converting minutes into hours like a pro in no time.
