Record time spent on project numbers accross a whole month timesheet.

Hello,


This is my first post here, so I am unsure if I am in the correct thread etc.

I am trying to record my teams overtime, based on time spent on a particular job number, from information that I would enter on a month timesheet.

The month timesheet would have my teams names on one axis, with the days of the month on the other. Splitting each day into sub columns/rows of Job No, Volume Completed, Time spent.

Under a seperate tab, I want to have an overview of total time spent etc on each job number.

I have done some research into vlookup, but it doens't seem the correct thing to use.

If i have not been clear enough, please let me know, and any help would be grateatly appreciated.

For a task like this, I would advise you to post an example file for people on the forum to work with. Just an example will do, don't include sensitive data.

Thanks for your quick response bmouse.

Please find attached an example of the type of thing I am trying to collate.

It may not be the best layout to achieve the results i need, so any tips, or changes in format to help me achieve what i am trying would be welcomed.

Cheers

Depending on how many people you have, you could try to use SUMIF, to count the time spent on a certain job.

Thanks bmouse. very quick reply, I have had a quick play with SUMIF, and that seems to work great.

With some layout changes i will be able to use the spreadsheet exactly as i planned.

THANKS