Payroll and overtime across a pay period

Below are two weeks of timesheets for six hourly employees at a dental practice, with hourly rates, a paid holiday, one employee who changed rate mid-period, and one who worked a split shift across midnight. Compute gross pay for each employee for the period under these rules: overtime at 1.5x for hours over 40 in a workweek (Sunday to Saturday); holiday hours are paid but do not count toward the 40; rate changes apply from the effective date; a shift belongs to the day it started. Show your work per employee, then end with a block starting with "ANSWER:" listing each employee and their gross pay to the cent, and the total.