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.

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.


How to Convert Minutes to Hundredths in Excel: 3 Easy Ways

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


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

  • Firstly, the TEXT function displays the (E6*24) value in (“00“) format_text.
  • Then the SUBSTITUTE function replaces the (“.“) old_text with (“:“) new_text.

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


Download Excel Workbook


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.


Related Articles


<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo