Hello all,
I have a payroll report that currently works ok however we are moving to bi-weekly pay periods but time is still paid weekly. Basically what I need will look like this for example
Employee Date Reg Hours OT Hours Other Hours Daily Total
Week 1: January 1-7, 2012
John Doe 1/1/12 8.0 1.5 0.0 9.5
John Doe 1/2/12 8.0 1.5 0.0 9.5
John Doe 1/3/12 8.0 1.5 0.0 9.5
John Doe 1/4/12 8.0 1.5 0.0 9.5 etc
Week 2: January 8-14, 2012
John Doe 1/5/12 8.0 1.5 0.0 9.5
John Doe 1/6/12 8.0 1.5 0.0 9.5
John Doe 1/7/12 8.0 1.5 0.0 9.5
John Doe 1/8/12 8.0 1.5 0.0 9.5 etc
Week 1 Totals 32.0 6.0 0.0 38.0
Week 2 Totals 32.0 6.0 0.0 38.0
PAY PERIOD TOTAL 64.0 12.0 0.0 72.0
I have a report that runs but I can't figure out how to get it to split the weeks and then total them. Can anyone help?
Thanks so much,
Dianne