This is part of a sheet that i have that totals employee hours and pay per week. It looks like this....
I'd like it to look like this without having to subtotal and total every one by hand....
Analyzed Site Payroll 9-13.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
Y | Z | AA | AB | AC | AD | AE | |||
1 | Day Rate | OT Rate | Straight Pay | OT Pay | Total | ||||
2 | $ 200.00 | $ 300.00 | $ 200.00 | $ 30.00 | |||||
3 | $ 200.00 | $ 300.00 | $ 100.00 | $ 150.00 | |||||
4 | $ 200.00 | $ 300.00 | $ 60.00 | $ 60.00 | |||||
5 | |||||||||
6 | |||||||||
7 | $ 220.00 | $ 330.00 | $ 220.00 | $ - | |||||
8 | $ 220.00 | $ 330.00 | $ - | $ - | |||||
9 | $ 220.00 | $ 330.00 | $ 330.00 | $ - | |||||
10 | $ 220.00 | $ 330.00 | $ 110.00 | $ - | |||||
11 | $ 220.00 | $ 330.00 | $ 176.00 | $ - | |||||
12 | $ 220.00 | $ 330.00 | $ 110.00 | $ - | |||||
13 | $ 220.00 | $ 330.00 | $ 110.00 | $ - | |||||
14 | $ 220.00 | $ 330.00 | $ 110.00 | $ - | |||||
15 | $ 220.00 | $ 330.00 | $ 220.00 | $ - | |||||
16 | |||||||||
17 | |||||||||
18 | $ 500.00 | $ 750.00 | $ - | $ - | |||||
19 | $ 500.00 | $ 750.00 | $ 850.00 | $ 225.00 | |||||
20 | $ 500.00 | $ 750.00 | $ 900.00 | $ - | |||||
21 | $ 500.00 | $ 750.00 | $1,000.00 | $ - | |||||
22 | $ 500.00 | $ 750.00 | $ 450.00 | $ 75.00 | |||||
23 | $ 500.00 | $ 750.00 | $ 250.00 | $ 375.00 | |||||
24 | |||||||||
WEEK OF 9-13 |
I'd like it to look like this without having to subtotal and total every one by hand....