Add up gross total to a particular job no.

Hello,

I am currently creating a time sheet for my employer. The timesheet is entered by the employee's each week and set back to the office. What accounts would like is the total gross amount on each shift, which would be assigned a job number to cost it to, is to total up the total cost to each job number. As a construction company are jobs numbers vary from 2200 to 4000.

I have attached the timesheet we are trying to use,

For an example:

If on Monday, Wednesday and Thursday the employee worked at job 2301, I would like the total from each of those days to be totalled up on the next page named Office use only

If you need more information please let me know

Thank you in advance

mcsquare