Hi guys,
I'm working on a scheduling/payroll sheet and I've stumped myself. I have one sheet that displays the shifts (12-8, 8-4, 4-12 format). The next sheet pulls off the schedule and calculates and totals hours worked. Employees who work between specific hours get incentive pay. I would like to have the sheet pull the data off the schedule sheet and calculate the total accumulated hour worked between 12am & 8am for each employee. Any ideas?