Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will show you how to convert hours and minutes to minutes in Excel. You will find 2 simple methods here to do so.
This is the dataset for today’s article. There are some time durations. I will use them to convert hours and minutes to minutes in Excel.
1. Using Multiplication to Convert Hours and Minutes to Minutes in Excel
The first method is the multiplication of time durations to convert them. The relationship between time units is,
1 Day = 24 Hours = 24*60 or 1440 Minutes
Let’s apply the method step by step.
- First of all, change the format of C5:C11 from General to Number. Select C5:C11.
- Then, go to the Home
- After that, select the icon shown in the image.
- Format Cells box will appear. Select Number.
- Then, change the decimal places to 0.
- After that, click OK.
- Then, go to C5 and write down the following formula
=B5*1440
- After that, press ENTER to get the output.
- Finally, use Fill Handle to AutoFill up to C11.
Read More: How to Convert Hours to Minutes in Excel
Similar Readings
- How to Convert Hours to Days in Excel
- How to Convert Time to Decimal in Excel
- Convert Epoch Time to Date in Excel
- Convert Military Time to Standard Time in Excel
- Excel Convert Seconds to hh mm ss
- How to Convert Time to Hours in Excel
- How to Convert Time to Minutes in Excel
2. Combining Excel HOUR and MINUTE Functions to Convert Hours and Minutes to Minutes
The next step is the use of the HOUR and MINUTE Functions to convert time durations. Let’s do it step by step.
Steps:
- Change the format of C5:C11 to Number following method-1.
- Then, go to C5 and write down the following formula
=HOUR(B5)*60+MINUTE(B5)
- Then, press ENTER to get the output.
- Then, use Fill Handle to AutoFill up to C11.
Read More: How to Convert Minutes to Hours and Minutes in Excel
How to Convert Minutes to Hours in Excel
You can also convert minutes to hours in Excel. In this section, I will show a simple way to do so. You can use the TIME function to convert minutes to hours in Excel.
Steps:
- First of all, you have to change the format of C5:C11. To do so,
- Select C5:C11.
- Then, go to the Home
- After that, select the icon shown below.
- Format Cells box will appear.
- Select Custom
- Type the format h “hour” mm “minute”.
- Then, click OK.
- After that, go to C5 and write down the formula
=TIME(0,B5,0)
- Press ENTER to get the output.
- Then, use Fill Handle to AutoFill up to C5:C11.
Read More: How to Convert Minutes to Seconds in Excel
Things to Remember
- 1 Day = 24 Hours = 24*60 or 1440 Minutes
Download Practice Workbook
Download this workbook and practice while going through the article.
Conclusion
In this article, I have explained how to convert hours and minutes to minutes in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.
Related Articles
- How to Convert Minutes to Tenths of an Hour in Excel
- How to Convert Seconds to Minutes in Excel
- Convert Time to Text in Excel
- How to Convert Milliseconds to Seconds in Excel
- Convert Minutes to Hundredths in Excel
- How to Convert Minutes to Days in Excel
- How to Convert Time to Seconds in Excel
- How to Convert Days to Hours in Excel
- How to Convert Hours to Percentage in Excel
- How to Convert Seconds to Hours and Minutes in Excel
- How to Convert Seconds to Hours Minutes Seconds in Excel
- How to Convert Time to Number in Excel
- How to Convert Minutes to Decimal in Excel
- How to Convert Hours to Decimal in Excel
- How to Convert Hours and Minutes to Decimal in Excel
- How to Convert Decimal Time to Hours and Minutes in Excel