Formula for overtime percentage in excel

Pat Smith
Pat Smith used Ask the Experts™
on
If I wanted to see what percentage of employees total work horse was overtime by using an excel formula overtime hours us 5 and total hours worked is 45. What would be the formula to use
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

The Mathematical  Percentage calculation would be Overtime Hours/Total Hours Worked.
In your case Formula would be =5/45 which is 0.111111, then format cell to percentage with 2 decimals which will be 11.11% Or 5/45*100
Finance Analyst
Commented:
Depends whether you want the overtime as a percentage of total time or of standard time.

For percentage of total time then as above suggestion from Shums.

If percentage of standard time, there would be a couple of options:

=45 / (45 - 5)  gives 1.125 or as a percentage would be 112.5%. if you want only the 12.5% then:

=1 - (45 / (45 - 5))

OR

= 5 / (45 - 5) = 0.125 or as a percentage 12.5%

Thanks
Rob H
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:
Split: Rob Henson (ID: 42066057) and Shums (ID: 42065306)

If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial