How to Convert Hours and Minutes to Minutes in Excel

Last updated: September 27, 2023
Get FREE Advanced Excel Exercises with Solutions!

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.

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.

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

Multiply to convert hours and minutes to minutes in excel

Read More: How to Convert Hours to Minutes in Excel


Similar Readings


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.

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


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)

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


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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo