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.

**Table of Contents**Expand

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

## How to Convert Hours to Percentage in Excel: 3 Easy Methods

Let’s get introduced to our dataset first. I have an arbitrary **Entry **and **Exit **time for several employees of the **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; the total working hours are **45 hours**. We will convert the working hours of **Rozer **to percentages using a **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, 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, first select cells
**F5**to**F8**. Secondly, from your**Home**ribbon, go to:

**Home → Number → Percentage**

- Finally, you will be able to convert hours to a percentage, which has been given in the below screenshot.

**Read More: **How to Convert Hours to Minutes in Excel

### 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 Hours to Days 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 working hours per day. We use the**dollar sign($)**for absolute reference. - Hence, 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: **How to Convert Days to Hours 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.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

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

**Related Articles**

- How to Convert Hours and Minutes to Minutes in Excel
- How to Convert Hours to Decimal in Excel
- How to Convert Hours and Minutes to Decimal in Excel

**<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel**