# How to Calculate Utilization Percentage in Excel: 3 Methods

### Method 1 – Calculate Utilization Percentage of Working Hours

✍️ Steps:

• Select a cell (i.e. C6) where you want to get the utilization percentage in respect of working hours.
• Type the following formula in that cell.

`=C4/C5`

• C4 = Working Hours
• C5 = Hours Avail to Work

• Press ENTER, and the cell will show the utilization rate in decimal format. Find out the rate in a percentage format.
• To convert decimal format to percentage format, just go to the Home tab> click Percentile Style from the Number group.

• Change the format and you will get the Utilization Percentage for the working hours of that company.

### Method 2 – Calculating Utilization Percentage of Products

✍️ Steps:

• Select a cell and apply the following formula to get the utilization rate. Dividing the output by the standard value will get you the utilization rate.

`=C4/C5`

• C4 = Toys Produced per Day
• C5 = Standard Production per Day

• Press ENTER and change the cell format to get the utilization percentage for products.

### Method 3 – Labor Utilization Percentage in Excel

`=C4/C5`

• C4 = Labour Worked per Day
• C5 = Total Workers per Day

Dividing the available number of workers by the total number of workers will result in the utilization percentage for labor.

## Related Articles

<< Go Back to Calculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF