Zehad Rian Jim
This tutorial will demonstrate how to convert minutes to hours and minutes in excel. We need to convert minutes into hours and minutes for our needs. Decimal time is commonly used in excel to track the record of a person’s time spent on a project. But converting minutes into hours and minutes is useful to calculate it easily. So, we need to learn to convert minutes to hours and minutes in excel.
Download Practice Workbook
You can download the practice workbook from here.
5 Easy Methods to Convert Minutes to Hours and Minutes in Excel
In this case, our goal is to convert minutes to hours and minutes in excel in 5 ways. To do that, we’ll use a sample dataset overview as an example in Excel to understand easily. In Column B we have Minutes and in column C we have Hours and Minutes. If you follow the methods correctly, you should learn how to convert minutes to hours and minutes in the excel formula yourself.
1. Using TEXT Function
The TEXT Function is mainly used to convert a numeric value to a particular formula for many purposes. In this case, we aim to convert minutes to hours and minutes in excel with this function. We will describe the steps of this method below.
Steps:
- First, in the C5 cell insert the following formula.
=TEXT(B5/(24*60),"[hh]:mm")
- After pressing the Enter button, you will get the result for the cell and then use the Fill Handle to apply the formula to all the desired cells.
- Finally, you will get the desired result.
Read More: How to Convert Minutes to Seconds in Excel (2 Quick Ways)
2. Use of CONVERT Function
In this case, our goal is to convert minutes to hours and minutes in excel by the CONVERT Function. This is the easiest option to change minutes in an excel sheet. Let’s describe the steps of this method below.
Steps:
- Firstly, in the C5 cell insert the following formula.
=CONVERT(B5,"mn","hr")
- Secondly, if you press the Enter button, you will get the result for the cell and then use the Fill Handle to apply the formula to all the desired cells.
- Thirdly, you will get the desired result.
Read More: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
3. Combining QUOTIENT and INT Functions
Our goal is to convert minutes to hours and minutes in excel by combining the INT and QUOTIENT functions. The INT Function is mainly used to return the integer part of a decimal number. The QUOTIENT function is mainly used for data entry or accounting as it doesn’t return any remainder. So, combining both functions can be very helpful in this case. Let’s describe the method with easy steps below in order.
Steps:
- To begin with, in the C5 cell insert the following formula.
=QUOTIENT(B5,60)&":"&IF(LEN(MOD(B5,60))=1,0,"")&MOD(B5,60)
- In addition, press the Enter button, and you will get the result for the cell, and then use the Fill Handle to apply the formula to all the desired cells.
- Finally, you will get the desired result.
🔎 How Does the Formula Work?
Read More: How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
Similar Readings
- How to Convert Minutes to Hundredths in Excel (3 Easy Ways)
- Convert Minutes to Days in Excel (3 Easy Methods)
- How to Convert Hours to Percentage in Excel (3 Easy Methods)
4. Manually Converting to Minutes and Hours
In this case, we aim to convert minutes to hours and minutes in excel by dividing. This is the easiest option to create in an excel sheet. Let’s describe the steps of this method below.
Steps:
- Firstly, in the C5 cell insert the following formula.
=B5/60
- Secondly, if you press the Enter button, you will get the result for the cell and then use the Fill Handle to apply the formula to all the desired cells.
- Thirdly, you will get the desired result.
Read More: Excel Convert Seconds to hh mm ss (7 Easy Ways)
5. Use of Custom Formatting
Excel has a custom format to transform decimals into time. Now, we aim to apply the custom format to fulfill our goal. The steps of this method are described below.
Steps:
- To begin with, in the C5 cell insert the following formula.
=B5/(24*60)
- Next, if you press the Enter button, you will get the result for the cell and then use the Fill Handle to apply the formula to all the desired cells.
- In addition, you will get the desired result.
- Furthermore, press right-clicks on the selected cells, and the Format Cells dialog box will open on the screen.
- Then, go to Number > Custom > Type > [h]:mm > OK.
- Finally, you will get the desired result.
Read More: How to Convert Seconds to Hours Minutes Seconds in Excel
How to Change Time to Decimal
At this point, we aim to change time to decimals. Recording time helps track attendance easily. But converting it into decimals helps to learn how much time a person has spent to complete the project. By that, one can easily understand the dedication level of another person. The steps of this method are described below.
Steps:
- At first, in the C5 cell insert the following formula.
=CONVERT(B5,"day","mn")
- Second, click the Enter button to get the result for the cell, and then use the Fill Handle to apply the formula to all the desired cells.
- Last, you will get the desired result.
Read More: Convert Decimal Coordinates to Degrees Minutes Seconds in Excel
Things to Remember
- Among all the methods, using the TEXT Function is the easiest to create and most efficient way to use it in all situations.
- If only you don’t want to use any formula, then you can use the Custom Format.
- No matter which method you have used, just learn it well enough so that you can understand its formula and final output.
Conclusion
Henceforth, follow the above-described methods. Thus, you will be able to convert minutes to hours and minutes in excel. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
