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

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

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.

Converting Minutes to Hundredths in Excel

In this article, we demonstrate how to use arithmetic operators and formulas to convert minutes to hundredths in Excel.


Download Excel Workbook


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.

Format Cells

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.

Multiplying by 24 to Convert Minutes to Hundredths in Excel

Read More: How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)


Similar Readings


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

Substitute and Text Functions

Step 2: Now, use the Fill Handle to convert the other minutes to hundredths as depicted in the picture below.

Outcome

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


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.

Modifying minutes to hundredths in Excel

Read More: How to Convert Minutes to Seconds in Excel (2 Quick Ways)


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

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

Leave a reply

ExcelDemy
Logo