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**hide

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

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

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

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

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

**Similar Readings**

**Convert Time to Text in Excel (3 Effective Methods)****How to Convert Seconds to Hours Minutes Seconds in Excel****Convert Minutes to Hundredths in Excel (3 Easy Ways)****How to Convert Minutes to Days in Excel (3 Easy Methods)**

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

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

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

**How to Convert Minutes to Seconds in Excel (2 Quick Ways)****Convert Seconds to Hours and Minutes in Excel (4 Easy Methods)****Excel Convert Seconds to hh mm ss (7 Easy Ways)****How to Convert Minutes to Tenths of an Hour in Excel (6 Ways)****Convert Seconds to Minutes in Excel****How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)**