Hi,

This is a Semi-Monthly Payroll Sheet
B5 to H5 = 7 days
I5 to O5 = 7 days
S5 = 1 day
T5 is hourly rate $8
U5 = Gross Pay (Need the formula inserted here)

If my worker works 49 hours the first 7 days. He will be paid overtime
for this.
If my worker works 15 hours the 2nd 7 days. There is no overtime
And the final day 1 hour. There is no overtime.

Notice the total hours add up to 65 hours.

--
Thank you