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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.
3 Suitable Ways to Convert Hours to Percentage in Excel
Let’s get introduced to our dataset first. I have an arbitrary Entry and Exit time of several employees of XYZ group in my sheet and I’ll convert the working hours to the percentage of those employees.
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 through the total working hours are 45 hours. We will convert the working hours of Rozer to percentages using 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.
- After that, write down the below formula in that cell.
=E5/D5
- Hence, simply, 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.
Step 2:
- Now, we will convert those fractions of hours into a percentage. To do that, firstly, select cells F5 to F8. Secondly, from your Home ribbon, go to,
Home → Number → Percentage
- Finally, you will be able to convert hours to percentage which has been given in the below screenshot.
Read More: How to Convert Hours to Days in Excel (6 Effective Methods)
Similar Readings
- Convert Time to Text in Excel (3 Effective Methods)
- How to Convert Seconds to Hours Minutes Seconds in Excel
- Convert Minutes to Hundredths in Excel (3 Easy Ways)
- How to Convert Minutes to Days in Excel (3 Easy Methods)
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.
- 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.
- 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.
Read More: How to Convert Minutes to Hours and Minutes 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.
- 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 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 9608.
- 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.
Read More: Convert Decimal Coordinates to Degrees Minutes Seconds 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.
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. And please visit our website ExcelDemy to explore more.
Related Articles
- How to Convert Minutes to Seconds in Excel (2 Quick Ways)
- Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)
- Excel Convert Seconds to hh mm ss (7 Easy Ways)
- How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)
- Convert Seconds to Minutes in Excel
- How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)