How to Convert Hours to Percentage in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

We often use hours in our worksheets for business purposes, educational purposes, and many others. Sometimes, we need to convert hours to percentages in the worksheet. We do it so that we can easily evaluate the performance of the employees of a company. Excel offers some quick ways to do it smartly. This article will provide you with three quick methods to convert hours to percentage in Excel effectively with appropriate illustrations.


Basic Formula to Calculate Percentage

We all know the basic percentage formula as below:

=(Part/Total)*100

In Excel, you won’t have to multiply ‘Part/Total‘ by 100 as stated above. This is because Excel automatically multiplies the result of the ‘=Part/Total’ portion by 100 when you apply the percent (%) Number format.

To illustrate, if an employee works 8 hours in a day (24 hours), then the percentage of time the employee has worked in a day will be as follows:

=(8/24)

Now, you might wonder whether the time format has any effect on the above calculation in Excel or not. Luckily, Excel stores time as a number; it displays a different number of time formats depending on our preference. For instance, in the above example, I have used the time format: hh:mm:ss. However, using that time format did not affect the percentage calculation. So, whatever the time format is, simply use the ‘=Part/Total‘ formula to calculate the percentage of the time.


How to Convert Hours to Percentage in Excel: 3 Easy Methods

Let’s get introduced to our dataset first. I have an arbitrary Entry and Exit time for several employees of the XYZ group in my sheet, and I’ll convert the working hours to the percentage of those employees.

convert hours to percentage in excel


1. Use Mathematical Formula to Convert Hours to Percentage

First of all, I will show you an example of calculating the percentage of hours using the basic percentage formula. From our dataset, we can easily do that. Suppose Rozer works 42 hours per week; the total working hours are 45 hours. We will convert the working hours of Rozer to percentages using a Mathematical formula. Let’s follow the instructions below to convert hours to percentage!

Step 1:

  • First of all, select cell F5 for the convenience of our work.

Use Mathematical Formula to Convert Hours to Percentage

  • After that, write down the below formula in that cell.
=E5/D5
  • Hence, press Enter on your keyboard. As a result, you will be able to get the return of the Mathematical formula and the return is 0.9333.

  • Further, AutoFill the formula to the rest of the cells in column F which has been given in the screenshot.

Use Mathematical Formula to Convert Hours to Percentage

Step 2:

  • Now, we will convert those fractions of hours into a percentage. To do that, first select cells F5 to F8. Secondly, from your Home ribbon, go to:

Home → Number → Percentage

  • Finally, you will be able to convert hours to a percentage, which has been given in the below screenshot.

Use Mathematical Formula to Convert Hours to Percentage

Read More: How to Convert Hours to Minutes in Excel


2. Apply MOD Function to Convert Hours to Percentage

In this section, we will apply the MOD function to convert hours to percentage. Using the MOD function, we will calculate the total working hours of the employees of the XYZ group. The total hours would be done by the employees are 8:30 hours. Hence, we calculate the hours to percentage. Let’s follow the instructions below to convert hours to percentage!

Step 1:

  • First of all, select cell F5 for the convenience of our work.
  • After that, write down the below MOD function in that cell.
=MOD(D7-C7,1)
  • Where D7 is the Exit time and C7 is the Entry time of the employees. D7-C7 is the number and 1 is the divisor of the MOD function.
  • Hence, press Enter on your keyboard. As a result, you will be able to get the return of the MOD function and the return is 8:05.

Apply MOD Function to Convert Hours to Percentage

  • Further, AutoFill the MOD function to the rest of the cells in column E which has been given in the screenshot.

Step 2:

  • After that, write down the below formula in that cell.
=E5/$E$4
  • Where E5 is the total working hours of Rozer. $E$4 is the total hours that would be done by We use the dollar sign($) for absolute reference.
  • Hence, simply, press Enter on your keyboard. As a result, you will be able to get the return of the formula and the return is 0.9510.

Apply MOD Function to Convert Hours to Percentage

  • Further, AutoFill the formula to the rest of the cells in column F.

  • Simply repeat Step 2 of method 1 to convert those fractions of hours into a percentage.

Apply MOD Function to Convert Hours to Percentage

Read More: How to Convert Hours to Days in Excel


3. Insert TEXT Function to Convert Hours to Percentage

Last but not the least, we will apply the TEXT function to convert hours to percentage in Excel. Using the TEXT function, we will calculate the total working hours of the employees of the XYZ group. The total hours would be done by the employees are 8:30 hours. Hence, we calculate the hours to percentage. Let’s follow the instructions below to convert hours to percentage!

Step 1:

  • First of all, select cell F5 for the convenience of our work.
  • After that, write down the below MOD function in that cell.
=TEXT(D7-C7,"hh:mm")
  • Where D7 is the Exit time and C7 is the Entry time of the employees. D7-C7 is the value and “hh:mm” is the format_text of the TEXT function.
  • Hence, press Enter on your keyboard. As a result, you will be able to get the return of the TEXT function and the return is 05.

Insert TEXT Function to Convert Hours to Percentage

  • Further, AutoFill the TEXT function to the rest of the cells in column E which has been given in the screenshot.

Step 2:

  • After that, write down the below formula in that cell.
=E5/$E$4
  • Where E5 is the total working hours of Rozer$E$4 is the total working hours per day. We use the dollar sign($) for absolute reference.
  • Hence, press Enter on your keyboard. As a result, you will be able to get the return of the formula and the return is 9608.

Insert TEXT Function to Convert Hours to Percentage

  • Further, AutoFill the formula to the rest of the cells in column F.

  • Simply repeat Step 2 of method 1 to convert those fractions of hours into a percentage.

Insert TEXT Function to Convert Hours to Percentage

Read More: How to Convert Days to Hours in Excel 


Things to Remember

➜ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

➜ The #VALUE! error occurs when any of the given inputs are non-numeric.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

I hope all of the suitable methods mentioned above to convert hours to percentage will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


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.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo