Good Morning,
I have to keep payroll for hourly employees. We have two pay periods and I am having some difficulty using the formulas in K9 and L9. Obviously it is not correct as the actual total pay hours are in J11 & J12.
What I am trying to accomplish is to have formulas that will put the actual “Pay Hours” in Cells K8 & L8. Something that will count the hour totals between cells K5 & K6 (including those dates) for “Pay period 1” and the same with cells L5 & L6..
Thanks in advance, JJ in SD
I have to keep payroll for hourly employees. We have two pay periods and I am having some difficulty using the formulas in K9 and L9. Obviously it is not correct as the actual total pay hours are in J11 & J12.
What I am trying to accomplish is to have formulas that will put the actual “Pay Hours” in Cells K8 & L8. Something that will count the hour totals between cells K5 & K6 (including those dates) for “Pay period 1” and the same with cells L5 & L6..
Thanks in advance, JJ in SD
Hourly Payroll.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
2 | Both | In | Out | IN | Out | Total Hours | Regular Hours | Overtime Hours | Daily Pay | Rate | ||||
3 | Date | $10.00 | ||||||||||||
4 | 28-Jun-05 | Tuesday | 8.00 | 12.00 | 13.00 | 17.00 | 8.00 | 8.00 | $80.00 | Pay Period 1 | Pay Period 2 | |||
5 | 29-Jun-05 | Wednesday | 8.00 | 12.00 | 13.00 | 18.00 | 9.00 | 8.00 | 1.00 | $95.00 | 28-Jun-05 | 1-Jul-05 | ||
6 | 30-Jun-05 | Thursday | 8.00 | 12.00 | 13.00 | 17.00 | 8.00 | 8.00 | $80.00 | 30-Jun-05 | 4-Jul-05 | |||
7 | 1-Jul-05 | Friday | 8.00 | 12.00 | 13.00 | 17.00 | 8.00 | 8.00 | $80.00 | Pay Hours | Pay Hours | |||
8 | 2-Jul-05 | Saturday | 8.00 | 12.00 | 13.00 | 18.00 | 9.00 | 8.00 | 1.00 | $95.00 | 17.50 | 25.50 | ||
9 | 3-Jul-05 | Sunday | 8.00 | 12.00 | 13.00 | 17.00 | 8.00 | 8.00 | $80.00 | |||||
10 | 4-Jul-05 | Monday | 8.00 | 12.00 | 13.00 | 17.00 | 8.00 | 8.00 | $80.00 | |||||
11 | 24.00 | 1.00 | 25.50 | Pay Hours 1 | ||||||||||
12 | 32.00 | 1.00 | 33.50 | Pay Hours 2 | ||||||||||
13 | 56.00 | 2.00 | 59.00 | Pay Hours T | ||||||||||
Time |