# Get OT hours worked as % of regular hours

#### zone709

##### Well-known Member
this may be an easy ? but trying to see if I'm right. I'm trying to get percentage of OT hours worked to regular hours for each job.

example lets say
reg time hours are 3,400 right then
Overtime hours are 275 then what's the percentage of overtime worked to regualr time? any help thanks.

Was thinking 3400+275 / 275 but not sure that's right

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Re: % ?

Try this

=B2/B1

Excel 2016 (Windows) 32 bit
ABC
1Reg Time34008%
2Overtime275
Sheet2

Re: % ?

Try this

=B2/B1

Excel 2016 (Windows) 32 bit
ABC
1Reg Time34008%
2Overtime275

</tbody>
Sheet2
Yeah your right thanks. I was dividing it into the total of both thanks

Re: % ?

I'm not trying to tell you your business, but it seems to me that the question should be "what percentage of total hours worked were overtime hours?". In which case, the formula would be 275/(3400+275) * 100% or, using Alkey's example: B2/(B1+B2).

Re: % ?

Last edited:
Re: % ?

Ok just tried to make it short.

Replies
1
Views
601
Replies
1
Views
331
Replies
1
Views
711
Replies
3
Views
3K
Replies
0
Views
1K

1,196,260
Messages
6,014,293
Members
441,813
Latest member
elevate

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back