# How to Convert Hours to a Percentage in Excel – 3 Methods

The dataset showcases Entry and Exit time of different employees.

To convert the working hours to a percentage:

### Method 1 – Use a Mathematical Formula to Convert Hours to Percentage

Rozer works 42 hours per week; the total working hours is 45 hours. Convert the working hours to percentages:

Step 1:

• Select F5.

• Enter the formula in that cell.
`=E5/D5`
• Press Enter.

The result is 0.9333.

• Drag down the Fill Handle to see the result in the rest of the cells.

Step 2:

• Convert the fractions of hours into a percentage. Select F5:F8.
• Go to:

Home â†’ Number â†’ Percentage

This is the output.

Read More: How to Convert Hours to Minutes in Excel

### Method 2 – Applying the MOD Function to Convert Hours to Percentage

Use the MOD function.

Step 1:

• Select F5.
• Enter the function in that cell.
`=MOD(D7-C7,1)`

D7 is the Exit time and C7 is the Entry time. D7-C7 is the number and 1 is the divisor of the MOD function.

• Press Enter to see the result:Â 8:05.

• Drag down the Fill Handle to see the result in the rest of the cells.

Step 2:

• Enter the formula.
`=E5/\$E\$4`

E5 is the total working hours of Rozer. \$E\$4 is the total working hours. The dollar sign(\$) is used for absolute reference.

• Press Enter to see the result: 0.9510.

• Drag down the Fill Handle to see the result in the rest of the cells.

• Repeat Step 2 of method 1 to convert the fractions of hours into a percentage.

Read More: How to Convert Hours to Days in Excel

### Method 3 – Using the TEXT Function to Convert Hours to Percentage

Step 1:

• Select F5.
• Enter the function in that cell.
`=TEXT(D7-C7,"hh:mm")`

D7 is the Exit time and C7 the Entry time. D7-C7 is the value and “hh:mm” is the format_text of the TEXT function.

• Press Enter to see the result: 05.

• Drag down the Fill Handle to see the result in the rest of the cells.

Step 2:

• Enter the formula.
`=E5/\$E\$4`

E5 is the total working hours of Rozer,Â \$E\$4 is the total working hours per day. The dollar sign(\$) is used for absolute reference.

• Press Enter to see the result: 9608.

• Drag down the Fill Handle to see the result in the rest of the cells.

• Repeat Step 2 of method 1 to convert the fractions of hours into a percentage.

Read More: How to Convert Days to Hours in ExcelÂ

## Things to Remember

âžœ The #VALUE! error occurs when inputs are non-numeric.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF