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 Days to Hours 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 Hours to 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 Hours to Days 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 Hours to Percentage in Excel
- How to Convert Hours to Decimal in Excel
- How to Convert Hours and Minutes to Decimal in Excel
<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!