Get OT hours worked as % of regular hours

[zone709]

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

 

[AlKey]

Re: % ?

Try this

=B2/B1

Excel 2016 (Windows) 32 bit
	A	B	C
1	Reg Time	3400	8%
2	Overtime	275
Sheet2

 

[zone709]

Re: % ?

Try this

=B2/B1

Excel 2016 (Windows) 32 bit

	A	B	C
1	Reg Time	3400	8%
2	Overtime	275

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Yeah your right thanks. I was dividing it into the total of both thanks

 

[MrIfOnly]

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

 

[Michael M]

Re: % ?

AND for future reference....can you please use an appropriate title for your threads...%?...isn't, please see rule #14 of our rules...in my tag

 

[zone709]

Re: % ?

Ok just tried to make it short.