How to Convert Minutes to Hours and Minutes in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

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 make it easier to understand. 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.

convert minutes to hours and minutes in excel


1. Use Excel TEXT Function to Convert Minutes to Hours and Minutes

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

Inserting Formula to convert minutes to hours and minutes in excel

  • 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.

Using Fill Handle to convert minutes to hours and minutes in excel

  • Finally, you will get the desired result.

Read More: How to Convert Seconds to Hours and Minutes in Excel


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:

  • First, in the C5 cell insert the following formula.
=CONVERT(B5,"mn","hr")

Inserting Formula to convert minutes to hours and minutes in excel

  • 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.

  • And you will get the desired result.

Read More: How to Convert Seconds to Minutes in Excel


3. Combine QUOTIENT and INT Functions to Get Hours and Minutes from Minutes

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)

Inserting Formula to convert minutes to hours and minutes in excel

  • 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?

  • IF(LEN(MOD(B5,60))=1,0,””)&MOD(B5,60): In the first portion, it represents the decimal values and converts the values into days.
  • QUOTIENT(B5,60): This portion takes the values in decimals and converts them into hours and minutes.

Read More: How to Convert Minutes to Decimal in Excel 


4. Manually Convert to Minutes and Hours from Minutes in Excel

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

Inserting Formula to convert minutes to hours and minutes in excel

  • 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


5. Use of Custom Formatting for Conversion Between Minutes and Hours

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)

Inserting Formula to convert minutes to hours and minutes in excel

  • 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.

Showing result to convert minutes to hours and minutes in excel

  • Furthermore, press right-clicks on the selected cells, and the Format Cells dialog box will open on the screen.

Format Cells to convert minutes to hours and minutes in excel

  • Then, go to Number > Custom > Type > [h]:mm > OK.

  • Finally, you will get the desired result.

Showing Result to convert minutes to hours and minutes in excel

Read More: How to Convert Minutes to 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.

Download Practice Workbook


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. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back to Convert Time to Hours | 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.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo