need help creating a timesheet to track one employee over different jobs

**pbneal** · 01-05-2011, 05:10 PM

I am working on a "time sheet" the way it is configured now is there is a sheet called jobs. this sheet has 3 columns (job #, Cust, Job). Then I have a sheet for each week of the year. these sheets have columns (date, job#, cust, job, operation, start time, end time, total time, and paid).
What I am trying to figure out is how to create a formula in the jobs sheet to total hours spent on each job over the life of the job. There will be a new sheet added each week.

Thanks for the help.

I have attached a sample of the file for evaluation. I am using 2003 or 2007 which ever would work better.

**MarvinP** · 01-05-2011, 05:35 PM

Hi pbneal,

I'd suggest not having your weekly jobs all on separate sheets. I've copy and pasted them all to the same sheet and then done what I think you want. If they are all in a single table they are much easier to work with. See the attached.