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

## 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%`

## How to Calculate Productivity Percentage in Excel: 3 Cases

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 laborers 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, to convert 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**.

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

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

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

## Practice Section

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

**Download Practice Workbook**

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

## 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. Thanks for your patience in reading this article.

## Related Articles

- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
- How to Calculate SLA Percentage in Excel
- How to Calculate Percentage of Budget Spent in Excel
- How to Calculate Utilization Percentage in Excel