# How to Convert Minutes to Hundredths in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Companies may use tenths or hundredths of minutes to calculate wages. As a result, it may be required to convert minutes to hundredths in Excel. Excel formulas constituted by Arithmetic Operators and combined functions convert minutes to hundredths with ease.

Let’s say we have a dataset that holds the working hours, and we want to convert the minutes into hundredths to find the employee’s wage. In this article, we demonstrate how to use arithmetic operators and formulas to convert minutes to hundredths in Excel.

## 3 Easy Ways to Convert Minutes to Hundredths in Excel

Users display typical working hours in hours: minutes (hh:mm) format. Normally, there is no issue with hours as there is an offered wage per hour. But users need to convert minutes to hundredths if companies have such a policy.

Follow the below section to convert minutes to hundredths in Excel.

### Method 1: Multiplying by 24 to Convert Minutes to Hundredths in Excel

Multiplying hh:mm by 24 converts minutes to hundredths. However, the cells need to be in General or Number format. To preformat the cells as General or Number, users need to click the Number Setting icon (Home > Number section) or press CTRL+1 to display the Format Cells window. Step 1: Type the following formula in any adjacent cells.

`=E6*24`
[….] E6 contains time in hh:mm format. Multiplying it with 24 converts minutes to hundredths. Step 2: Drag the Fill Handle to convert the other cells as shown in the latter picture. ### Method 2: Using SUBSTITUTE and TEXT Functions to Convert Minutes to Hundredths

Also, users can display the method 1 outcomes with custom cell formatting without ever preformatting the cells.

Step 1: Insert the below formula into any blank cells.

`=SUBSTITUTE(TEXT(E6*24,"00.00"),".",":")`

Formula Breakdown Step 2: Now, use the Fill Handle to convert the other minutes to hundredths as depicted in the picture below. ### Method 3: Using TEXT and FLOOR Functions to Convert Minutes with Custom Format

As an alternative to method 1, users can use the TEXT and MINUTE functions to fetch the hours and minutes, respectively. Then the FLOOR function returns the hundredths of minutes up to the assigned multiples.

Step 1: Paste the formula into the F6 cell.

`=TEXT(E6,"[hh]") & ":" & FLOOR(MINUTE(E6)*100/60,1)`

Formula Breakdown

• The TEXT function brings in the hours.
• The MINUTE function fetches the minutes from the E6 Then it converts the minutes to hundredths by multiplying them by 100/60.
• The FLOOR function takes MINUTE(E6)*100/60 as its number 1 is assigned as Significance. Significance is the multiple which is used to round the resultant value.
• Finally, the Ampersand (&) concatenates the portions with a “:” between them. Step 2: Use the Fill Handle to apply the formula to other cells. ## Conclusion

This article discusses cell formatting and ways to convert minutes to hundredths in Excel. Only method 1 requires cells to be preformatted. Other methods use formulas that format the outcomes automatically. We hope these methods help you understand the conversion. Use any of the methods to achieve your requirements.

Check out our awesome website, Exceldemy, to find interesting articles on Excel.

## Related Articles #### Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  