In Microsoft Excel, we can show the time in several formats. Among them, sometimes, we need to convert the minutes into the tenths of an hour. In this article, we will demonstrate to you **six** handy methods to convert minutes to tenths of an hour in Excel. If you are also curious about it, download our practice workbook and follow us.

**Table of Contents**Expand

## How to Convert Minutes to Tenths of an Hour in Excel: 6 Ways

To demonstrate the approaches, we consider a dataset of **10** employees of an organization. Their name and working hours are shown in our dataset, in the range of cells **B5:E14**. So, we will show our converted result in column **F**.

**📚 Note: **

All the operations of this article are accomplished by using **Microsoft Office 365** application.

### 1. Using PRODUCT Function

In this method, we will use **the PRODUCT function** to convert the minutes to the tenth of an hour In Excel. The steps of this process are given below:

**📌 Steps: **

- First of all, select cell
**F5**. - Now, write down the following formula into the cell.

`=PRODUCT(E5,24)`

- Press
**Enter**.

- Then,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will get all the minutes of the duration converted into the tenth of an hour.

Thus, we can say that our formula works perfectly, and we are able to convert minutes to tenths of an hour in Excel.

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

### 2. Utilizing Conventional Formula

In this process, we are going to use a conventional formula to convert the minutes to the tenth of an hour In Excel. The steps of this approach are given as follows:

**📌 Steps: **

- First, select cell
**F5**. - After that, write down the following formula inside the cell.

`=E5*24`

- Then, press
**Enter**.

- Next,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will figure out that all the minutes of the duration are converted into the tenth of an hour.

So, we can say that our formula works precisely, and we are able to convert minutes to tenths of an hour in Excel.

**Read More:** How to Convert Minutes to Decimal in Excel

### 3. Applying HOUR and MINUTE Functions

In this approach, we will use the **HOUR** and **MINUTE** functions to convert the minutes to the tenth of an hour In Excel. The steps of this procedure are shown below:

**📌 Steps: **

- At first, select cell
**F5**. - Next, write down the following formula inside the cell.

`=HOUR(E5)+MINUTE(E5)/60`

- Press the
**Enter**button.

- Afterward,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will see all the minutes of the duration converted into the tenth of an hour.

Hence, we can say that our formula works effectively, and we are able to convert minutes to tenths of an hour in Excel.

**🔎 Breakdown of the Formula**

We are breaking down the formula for cell **F5**.

`👉`

**MINUTE(E5)**: The **MINUTE** function extracts the minutes from the cell. Here, the function returns **30**.

`👉`

**HOUR(E5)**: The **HOUR** function returns the hour value. Here, the value is **7**.

`👉`

**HOUR(E5)+MINUTE(E5)/60:** Finally, this formula joins the result of both functions and shows us the final converted result. For this cell, the formula returns **7.5**.

**Read More: **How to Convert Seconds to Minutes in Excel

### 4. Using MROUND and PRODUCT Functions

In the following procedure, the **MROUND** and **PRODUCT** functions will help us to convert the minutes to the tenth of an hour In Excel. The procedure is described below step-by-step:

**📌 Steps: **

- At the beginning of this approach, select cell
**F5**. - Now, write down the following formula inside the cell.

`=MROUND(PRODUCT(E5,24),"0:06")`

- Then, press the
**Enter**button.

- Afterward,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will see all the minutes of the duration converted into the tenth of an hour.

Therefore, we can say that our formula works successfully, and we are able to convert minutes to tenths of an hour in Excel.

**🔎 Breakdown of the Formula**

We are breaking down the formula for cell **F5**.

`👉`

**PRODUCT(E5,24)**: The **PRODUCT** function converts the minutes into the tenth of an hour. For this cell, the function returns **7.5**.

`👉`

**MROUND(PRODUCT(E5,24),”0:06″)**: Here, the formula returns **7.5**.

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

### 5. Combining HOUR, MINUTE and ROUND Functions

In this case, the **HOUR**, **MINUTE**, and **ROUND** functions will help us to convert the minutes to the tenth of an hour In Excel. The procedure is explained below step-by-step:

**📌 Steps: **

- Firstly, select cell
**F5**. - After that, write down the following formula inside the cell.

`=HOUR(E5) & "." & ROUND(MINUTE(E5)/6,0)`

- Press
**Enter**.

- Now,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will see all the minutes of the duration converted into the tenth of an hour.

At last, we can say that our formula works effectively, and we are able to convert minutes to tenths of an hour in Excel.

**🔎 Breakdown of the Formula**

We are breaking down the formula for cell **F5**.

`👉`

**MINUTE(E5)**: The **MINUTE** function extracts the minutes from the cell. Here, the function returns **30**.

`👉`

**ROUND(MINUTE(E5)/6,0)**: The **ROUND** function round up the divisional value of the **MINUTE** function and **6**. Here, the formula returns **5**.

`👉`

**HOUR(E5)**: The **HOUR** function returns the hour value. Here, the value is **7**.

`👉`

**HOUR(E5) & “.” & ROUND(MINUTE(E5)/6,0)**: Finally, this formula shows us the final converted result. For this cell, the formula returns **7.5**.

**Read More: **How to Convert Minutes to Seconds in Excel

### 6. Utilizing ROUNDDOWN, MINUTE and HOUR Functions

In the final approach, we are going to use the **HOUR**, **MINUTE**, and **ROUNDDOWN** functions to convert the minutes to the tenth of an hour In Excel. The steps of this method are given as follows:

**📌 Steps: **

- In the beginning, select cell
**F5**. - Then, write down the following formula inside the cell.

`=HOUR(E5) & "." & ROUNDDOWN(MINUTE(E5)/6,0) & " Hours "`

- Press
**Enter**.

- After that,
**double-click**on the**Fill Handle**icon to copy the formula up to cell**F14**.

- You will notice all the minutes of the duration converted into the tenth of an hour.

Finally, we can say that our formula works successfully, and we are able to convert minutes to tenths of an hour in Excel.

**🔎 Breakdown of the Formula**

We are breaking down the formula for cell **F5**.

`👉`

**MINUTE(E5)**: The **MINUTE** function extracts the minutes from the cell. Here, the function returns **30**.

`👉`

**ROUNDDOWN(MINUTE(E5)/6,0)**: The **ROUNDDOWN** function round up the divisional value of the **MINUTE** function and **6**. Here, the formula returns **5**.

`👉`

**HOUR(E5)**: The **HOUR** function returns the hour value. Here, the value is **7**.

`👉`

**HOUR(E5) & “.” & ROUNDDOWN(MINUTE(E5)/6,0) & ” Hours “**: Finally, this formula shows us the final converted result. For this cell, the formula returns **7.5 Hours**.

**Read More: **How to Convert Minutes to Hundredths in Excel

**Download Practice Workbook**

Download this practice workbook for practice while you are reading this article.

## Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to convert minutes to tenths of an hour in Excel. Please share any further queries or recommendations with us in the comments section below if you have any other questions or suggestions.

## Related Articles

- Excel Convert Seconds to hh mm ss
- How to Convert Milliseconds to Seconds in Excel
- How to Convert Seconds to Hours Minutes Seconds in Excel
- How to Convert Minutes to Days in Excel

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

Hi Soumik,

This was VERY good information and easy to understand.

I have a more complex time formula that I need guidance with, maybe you can help. I believe that I need to write and ‘if, than’ formula to accomplish it.

The minute tenths fraction of time need to follow result:

0-3 = .0

4-9 = .1

10-15 = .2

16-21 = .3

22-27 = .4

28-33 = .5

34-39 = .6

40-45 = .7

46-51 = .8

52-57 = .9

58-60 = 1.0

How would you create a formula that would achieve those results?

Hey there!

We understand your problem that you shared here. Based on the scenario you have provided, there can be two possible cases of your problem and solution.

Case -1If you want to convert the minute span into the tenths fraction of time as you mentioned. For example,

0-3 = .0

4-9 = .1

10-15 = .2

16-21 = .3

…….

58-60 = 1.0

You can simply use the formula to convert it into tenth fraction. (Yes, you are right, we will use multiple IF function to achieve it)

=IF(AND(A1>=0, A1<=3), 0, IF(AND(A1>=4, A1<=9), 0.1, IF(AND(A1>=10, A1<=15), 0.2, IF(AND(A1>=16, A1<=21), 0.3, IF(AND(A1>=22, A1<=27), 0.4, IF(AND(A1>=28, A1<=33), 0.5, IF(AND(A1>=34, A1<=39), 0.6, IF(AND(A1>=40, A1<=45), 0.7, IF(AND(A1>=46, A1<=51), 0.8, IF(AND(A1>=52, A1<=57), 0.9, IF(AND(A1>=58, A1<=60), 1, "Out of Range"))))))))))))Replace

A1with the cell reference where your time value is located.This formula uses nested IF statements to check the given conditions and return the corresponding result based on the specified ranges. If the value is outside the specified ranges, it will return “Out of Range.” Adjust the cell reference and the ranges as needed for your specific use case.

Case -2In this case, if you want to convert the time

7:25:00(hh:mm:ss) into7.4. You can use the formula to convert it. Say, the value7:25:00is stored in cellA1.=IF(AND(MINUTE(A1)>=0,MINUTE(A1)<=3),HOUR(A1)+0,IF(AND(MINUTE(A1)>=4,MINUTE(A1)<=9),HOUR(A1)+0.1,IF(AND(MINUTE(A1)>=10,MINUTE(A1)<=15),HOUR(A1)+0.2,IF(AND(MINUTE(A1)>=16,MINUTE(A1)<=21),HOUR(A1)+0.3,IF(AND(MINUTE(A1)>=22,MINUTE(A1)<=27),HOUR(A1)+0.4,IF(AND(MINUTE(A1)>=28,MINUTE(A1)<=33),HOUR(A1)+0.5,IF(AND(MINUTE(A1)>=34,MINUTE(A1)<=39),HOUR(A1)+0.6,IF(AND(MINUTE(A1)>=40,MINUTE(A1)<=45),HOUR(A1)+0.7,IF(AND(MINUTE(A1)>=46,MINUTE(A1)<=51),HOUR(A1)+0.8,IF(AND(MINUTE(A1)>=52,MINUTE(A1)<=57),HOUR(A1)+0.9,IF(AND(MINUTE(A1)>=58,MINUTE(A1)<=60),HOUR(A1)+1,"Out of Range")))))))))))It will show

7.4instead of7:25:00.You can use this formula for your dataset. To do so, replace

A1with the cell reference where your time value is located.Thanks for choosing us. And we will be happy to solve your problem and answer your query regarding Excel.

RegardsExcelDemy Team