Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Convert Hours to Minutes in Excel (3 Easy Ways)

Looking for ways to know how to convert hours to minutes in Excel? We can convert hours to minutes by going through some easy steps. Here, you will find 3 ways to convert hours to minutes in Excel.


Download Practice Workbook


3 Ways to Convert Hours to Minutes in Excel

Here, we have a dataset containing the Movie Name and Duration in h:mm format. Now, we will show you how to convert hours to minutes in Excel using this dataset.

Ways to Convert Hours to Minutes in Excel


1. Using Format Cells Feature to Convert Hours to Minutes in Excel

In the first method, we will show you how to convert minutes to seconds using the Format Cells feature in Excel.

Using Format Cells Feature to Convert Hours to Minutes in Excel

Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell range D5:D11 and Right-click on it.

  • Then, select Format Cells.

  • Now, the Format Cells box will appear.
  • After that, select Number format and set 0 as Decimal places.
  • Next, click on OK.

Opening Format Cells Box to Convert Hours to Minutes in Excel

  • Then, select Cell D5.
  • After that, Insert the following formula.
=C5*1440

Here, as we know, 1 Day = 24 hours and 1 Hour = 60 minutes, so we multiplied Cell C5 by 24*60 which is 1440 to convert the time in hours to minutes in Excel.

  • Next, press ENTER.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the values of time in hours to minutes using the Format Cells feature in Excel.

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


2. Use of Arithmetic Formula to Convert Hours to Minutes in Excel

Now, we will show you how to convert hours to minutes using the Arithmetic Formula in Excel. Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell D5.
  • Then, insert the following formula.
=C5*1440

Use of Arithmetic Formula to Convert Hours to Minutes in Excel

Here, as we know, 1 Day = 24 hours and 1 Hour = 60 minutes, so we multiplied Cell C5 by 24*60 which is 1440 to convert the time in hours to minutes in Excel.

  • Next, press ENTER.

  • Now, select Cell D5.
  • After that, go to the Home tab >> select General from Number Format.

  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the values of time in hours to minutes using the Arithmetic Formula in Excel.

How to Convert Hours to Minutes in Excel Using Arithmetic Formula

Read More: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)


Similar Readings


3. Using CONVERT Function to Convert Hours to Minutes

We can also use the CONVERT Function to convert hours to seconds in Excel. The CONVERT Function can convert data from one unit to another. We can use this function to convert hours to minutes if the value is only in hours. Such as, It can not convert h:mm formatted hours value to minutes.

Here, we have a dataset containing the Subject Name and Exam Time in Hours. Now, we will use this dataset to convert hours to minutes in Excel.

Using CONVERT Function to Convert Hours to Minutes

Go through the following steps given below to do it on your own dataset.

Steps:

  • In the beginning, select Cell D5.
  • After that, insert the following formula.
=CONVERT(C5,"hr","mn")

Here, in the CONVERT Function, we inserted Cell C5 as number, “hr” as from_unit and “mn” as to_unit.

  • Now, press ENTER.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the time values in minutes using the CONVERT Function in Excel.

Read More: Convert Time to Minutes in Excel (5 Suitable Methods)


Applying HOUR and MINUTE Functions to Convert Hours to Minutes in Excel

Additionally, here, we will show you how you can convert hours and minutes to seconds by applying the HOUR and MINUTE functions in Excel.

Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell D5.
  • After that, insert the following formula.
=HOUR(C5)*60+MINUTE(C5)

Applying HOUR and MINUTE Functions to Convert Hours to Minutes in Excel

  • Now, select Cell D5.
  • Then, go to the Home tab >> select General from Number Format.

  • Next, press ENTER.
  • After that, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

  • Finally, you will get the values of time in hours and minutes to minutes using the HOUR and MINUTE functions in Excel.

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


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 3 ways to convert hours to minutes in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo