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.


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.

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

Use Mathematical Formula to Convert Hours to Percentage

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

Use Mathematical Formula to Convert Hours to Percentage

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.

Use Mathematical Formula to Convert Hours to Percentage

Read More: How to Convert Hours to Days in Excel (6 Effective Methods)


Similar Readings


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

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

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: 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

Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo