Hi, I wonder if you can help me.

I have been instructed to create a rather complex timesheet for each staff
member in my company. We are a company of engineers, many of whom are
contracted and as we work on more than one job at a time we need a way of
keeping track of who's doing what on which job and for how long.

Each job has a 4 digit job number (e.g. 2001) and each type of design has a
3 digit sub category (e.g. 100)

Not only does the spreadsheet need to calculate how many hours a week each
staff member works, we also need to know how many hours worked on each job
and separate from that how many hours worked on each sub category for each
job.

Each staff member's timesheet has to be linked to a master page which shows
the total hours worked by the company and also total on each job and each sub
category

I dont know if I have made that clear enough or even if i am asking the
right person! If not please let me know where else I can go for this advice.

Many Thanks