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.
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.
Step 1: Type the following formula in any adjacent cells.
=E6*24
Step 2: Drag the Fill Handle to convert the other cells as shown in the latter picture.
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.
Step 2: Now, use the Fill Handle to convert the other minutes to hundredths as depicted in the picture below.
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.
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
- How to Convert Minutes to Decimal in Excel
- How to Convert Milliseconds to Seconds in Excel
- How to Convert Seconds to Hours Minutes Seconds in Excel
- Excel Convert Seconds to hh mm ss
- How to Convert Minutes to Days in Excel
- How to Convert Seconds to Hours and Minutes in Excel
- How to Convert Seconds to Minutes in Excel
<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel