[TSuraco]

I have a timesheet problem. I have more than one job numbre and the sheet
calculates all time as straight time if it'sunder 40 hours, but our guys work
50 hr weeks. The other time is usually on one to two more job numbers. I can
get the summary page to show the overtime, but I can't get each individual
page to calculate it. i.e. I had a guy work 48 hours, 24 on one project, 16
on another & 8 on the last. His ot needs to be distributed evenly across the
jobs. manually, I took 8 & divided by the number of hours on each job to get
the percentage of OT on that job, but I can't get Excel to do it. Help!

[joel]

A B C

1 Regular Time OverTime
2 24 20 4
3 16 13.33333333 2.666666667
4 8 6.666666667 1.333333333

6 48 40 8

8 percentage overtime 1.2


Formulas
A B C

1 Start cell Regular Time OverTime
2 24 =A2/$B$8 =A2-C2
3 16 =A3/$B$8 =A3-C3
4 8 =A4/$B$8 =A4-C4

6 =SUM(A2:A4) =SUM(C2:C4) =SUM(D2:D4)

8 percentage overtime =A6/40


"TSuraco" wrote:

I have a timesheet problem. I have more than one job numbre and the sheet
calculates all time as straight time if it'sunder 40 hours, but our guys work
50 hr weeks. The other time is usually on one to two more job numbers. I can
get the summary page to show the overtime, but I can't get each individual
page to calculate it. i.e. I had a guy work 48 hours, 24 on one project, 16
on another & 8 on the last. His ot needs to be distributed evenly across the
jobs. manually, I took 8 & divided by the number of hours on each job to get
the percentage of OT on that job, but I can't get Excel to do it. Help!