Cost jobs based on hours and job number

Our company assigns job numbers to each employee's daily hours, for job costing purposes. I've tried to create a spreadsheet that would automatically compile costing data, but with no luck. Can someone show me how to compile each employee's total hours for each job number? Then I need to make a list of the jobs worked that week, with their applied wages.

The attached sheet shows what I do manually. It's so slow, I might as well be using clay tablets and a stylus. I just need a way to populate the Weekly Summary automatically.

Thanks for your help.

Payroll Summary.xlsm

Hi

I think I have what you want, take a look at the attached. I dont entirely agree with how you apportion the OT payment (all on Friday?), so I apportioned it based on the hours worked each day relative to 8 standard hours

Let me know what you think?