How to Convert Hours and Minutes to Minutes in Excel

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.

Steps:

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

Multiply to convert hours and minutes to minutes in excel

  • 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

Multiply to convert hours and minutes to minutes in excel

  • After that, press ENTER to get the output.

Multiply to convert hours and minutes to minutes in excel

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


Similar Readings


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.

HOUR and MINUTE functions Multiply to convert hours and minutes to minutes in excel

  • Then, go to C5 and write down the following formula
=HOUR(B5)*60+MINUTE(B5)

  • Then, press ENTER to get the output.

HOUR and MINUTE functions Multiply to convert hours and minutes to minutes in excel

  • Then, use Fill Handle to AutoFill up to C11.

HOUR and MINUTE functions Multiply to convert hours and minutes to minutes in excel

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)

Minutes to Hour

  • Press ENTER to get the output.

  • Then, use Fill Handle to AutoFill up to C5:C11.

Minutes to Hour

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

Akib Bin Rashid

Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo