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

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.


Download Practice Workbook

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


6 Quick Methods to Convert Minutes to Tenths of an Hour in Excel

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.

Using PRODUCT Function to Convert Minutes

  • 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.

Using PRODUCT Function to Convert Minutes to Tenths 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.

Utilizing Conventional Formula to change Minutes into Tenths

  • 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.

Utilizing Conventional Formula to Convert Minutes to Tenths 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 Hundredths in Excel (3 Easy Ways)


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.

Applying HOUR and MINUTE Functions to Transform Minutes into Tenth

  • 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.

Applying HOUR and MINUTE Functions to Convert Minutes to Tenths 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: Convert Decimal Coordinates to Degrees Minutes Seconds in Excel


Similar Readings


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.

Using MROUND and PRODUCT Functions to turn Minutes to Tenths

  • 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.

Using MROUND and PRODUCT Functions to Convert Minutes to Tenths 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: Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)


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.

Combining HOUR, MINUTE and ROUND Functions to Change Minutes to Tenths

  • 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.

Combining HOUR, MINUTE and ROUND Functions to Convert Minutes to Tenths 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 Seconds to Minutes 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.

Utilizing ROUNDDOWN, MINUTE and HOUR Functions to Transform Minutes to Tenths

  • 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.

Utilizing ROUNDDOWN, MINUTE and HOUR Functions to Convert Minutes to Tenths 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 Seconds in Excel (2 Quick Ways)


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.

Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo