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

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

## Related Articles 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 Advanced Excel Exercises with Solutions PDF  