Certainly, you can easily **calculate a percentage** in Microsoft Excel, powerful software for calculations. Productivity is a common term in economics. So, you may need to calculate the productivity percentage in Excel. In terms of calculation, Excel shines with its enormous formulas and features. You can also calculate the productivity percentage in Excel. In this article, we are going to show you how to calculate productivity percentage in Excel. So, letâ€™s get started.

**Table of Contents**hide

## Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.

## What Is Productivity Percentage?

Productivity is defined as the ratio of the total output and the total input. You can calculate the productivity of labor, products, and machines. A good productivity percentage lies between 70-75%. It means that workers spend 75% of their time producing and 25% of their time resting or doing unproductive work. A good productivity percentage is a must for making a profit for a company. The total output income of a company is divided by the total input workload to gain the productivity percentage. So, the arithmetic formula to calculate the productivity range is as follows.

`% of Productivity=(Total Input/Total Output)â•³100%`

## 3 Cases to Calculate Productivity Percentages in Excel

This section covers 3 diverse cases to calculate productivity percentages. The most common thing while calculating productivity percentages is that you have to divide the actual or target production by the achieved or output production first. Then you need to **convert the number into percentages**. To make your Excel journey smoother, weâ€™ll show you a different way to show the percentage for each case. Here, we have taken a dataset of a companyâ€™s **Total Output** and **Total Working Inputs**. We took the *No. of Labors* and their corresponding *Working Hours*, *No. of Machines* with their *Working Time*, *No of Products produced* *Per Day,* and the *No. of Employees*.

Not to mention, we have used the** Microsoft 365** version. You can use any other version at your convenience.

### 1. Finding Labor Productivity Percentage

You can calculate the labor productivity percentage by the ratio of the total output income and the total working hours of the labor force. You can get the total working hours of the laborers by multiplying the total labor by the working hours per day. Then we convert it to a percentage using the **Percent Style **button. Follow the steps to get a proper idea.

**ðŸ“Œ**** Steps:**

- First, you must multiply the number of labors by their corresponding working hours per day.
- To do the operation, go to cellÂ
**F5**and enter the formula

**=C5*D5**

- Consequently, press
**ENTER**and drag down the**Fill Handle**tool for other cells.

- Then, move to cell
**G5**and write up the formula.

**=C5/F5**

It will divide the **Output Amount** by the **Total Working Hours**.

Eventually, you will get productivity. Now, you need to convert it into percentages.

- Afterward, for converting the values into percentages, select the entire column of
**G**and go to the**Home**tab >> choose**Percent Style**under the**Number**command.

Finally, you will get the **Productivity Percentage**.

**Read More: ****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

### 2. Finding the Productivity Percentage of Machines

It also follows the same procedure to calculate the **Productivity of the Machine** while calculating the **Productivity of the Labor**. Here we describe the use of the **Format Cells** method to show the percentage. Go through the steps to do it.

**ðŸ“Œ**** Steps:**

- Firstly, go to cell
**F5**and insert the formula to get the**Total working Hours of Machines**.

**=D5*E5**

Here,

**D5 = Machine Working Hours**.

**E5 = No. of Machines.**

- Subsequently, press
**ENTER**, and you will get the result just like the image below.

- Then, go to cell
**G5**and enter the formula.

**=C5/F5**

It will divide the value of **C5** by the value of **F5** to get **Productivity**.

- You will get your answer after pressing
**ENTER**and dragging it down gradually.

- Now, for converting to the percentages, select the entire range and go to the
**Home**tab >> click on**Number Format**.

- After that, the
**Format Cells**dialog box will appear. From there select**Percentage**and hit**OK**.

*Note: **Just press CTRL + 1 to open the Format Cells dialog box.*

Finally, you will get the desired result in the percentage format.

**Read More: ****How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

**Similar Readings**

**How to Make Cumulative Percentage Polygon in Excel****Show One Number as a Percentage of Another in Excel****Calculate Percentage Based on Conditional Formatting (6 Ways)****How to Use IF and Percentage Formula in Excel (2 Easy Ways)****Apply Percentage Formula in Excel for Marksheet (7 Applications)**

### 3. Estimating the Productivity Percentage of Products

Generally, you can calculate the productivity percentage of products by dividing the output income by the total number of products. Thus, you will get productivity for each product. Next, convert the decimal value into percentages by applying the keyboard shortcut. We have attached the steps to give you a basic visualization.

**ðŸ“Œ**** Steps:**

- Firstly, select cell
**E5**, and enter the formula.

**=C5/D5**

- Then, press
**ENTER**and drag it down for other cells.

- Sequentially, you will get the result in decimal format.

- Now, select the entire range of
**Productivity**and simply press**CTRL + SHIFT + 5**to get the result in percentages form.

So, your result will look like the image above.

**Read More: ****How to Calculate Utilization Percentage in Excel (3 Cases)**

## How to Calculate Productivity Per Employee

Sometimes, you may need to calculate per-employee productivity, or how much production is available per employee. Though it is a process to calculate productivity, it is not displayed through percentages. Follow the steps to do it.

**ðŸ“Œ**** Steps:**

- Initially, move to cell
**E5**and insert the formula.

**=C5/D5**

Basically, it will divide the value of **C5**, which is the total output amount for your production, by the total number of employees.

Eventually, you will get the **Per Employee Productivity** after pressing **ENTER** and dragging it down to cell **E9**.

**Read More: ****Calculate Percentage of Filled Cells in Excel (7 Easy Ways)**

## Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

## Conclusion

Thatâ€™s all about todayâ€™s session. And these are some easy methods on how to convert time zones in excel Please let us know in the comments section if you have any questions or suggestions. For a better understanding please download the practice sheet. Visit our website **Exceldemy**, a one-stop Excel solution provider, to find out diverse kinds of excel methods. Thanks for your patience in reading this article.

## Related Articles

**How to Calculate Contribution Percentage with Formula in Excel****How to Calculate ROI Percentage in Excel (6 Easy Ways)****Calculate Total Percentage from Multiple Percentages in Excel****How to Calculate Savings Percentage in Excel (3 Easy Ways)****Calculate Error Percentage in Excel (3 Easy Methods)****How to Calculate SLA Percentage in Excel (with Quick Steps)****Use Excel Formula to Calculate Percentage of Grand Total**