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.
Download Practice Workbook
Download this workbook and practice while going through the article.
2 Simple Methods to Convert Hours and Minutes to Minutes in Excel
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. Use Multiplication to Convert Hours and Minutes to Minutes
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 (3 Easy Ways)
Similar Readings
- How to Convert Hours to Days in Excel (6 Effective Methods)
- Convert Decimal Coordinates to Degrees Minutes Seconds in Excel
- Convert Epoch Time to Date in Excel (2 Easy Methods)
- Convert Military Time to Standard Time in Excel (2 Suitable Ways)
- Excel Convert Seconds to hh mm ss (7 Easy Ways)
2. Combine 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
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 (2 Quick Ways)
Things to Remember
- 1 Day = 24 Hours = 24*60 or 1440 Minutes
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. Please visit Exceldemy for more useful articles like this.
Related Articles
- How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
- How to Convert Seconds to Minutes in Excel
- Convert Time to Text in Excel (3 Effective Methods)
- How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)
- Convert Minutes to Hundredths in Excel (3 Easy Ways)
- How to Convert Minutes to Days in Excel (3 Easy Methods)