Obtaining totals by reference number

[anaj]

Hello all.

I am having trouble with something at work, it might be pretty easy for some of you, but I just don't have idea how to solve this.
We have different jobs that we identify by their specific job number; each job have different cost codes that we use to keep up with budget.

I have attached an example of the time sheet which includes 3 workers and their time for one week. It specifies the job they were working on and the task (code), total hours and $ by worker
I need to get the total labor hours and labor $ for each job by code.
I also wrote some questions in the example.
I would really appreciate your help.
Thank you.