Table calculating multiple project hours by multiple employees

M

Mike Lewis

I'd use a simple list like:

Name Month Project Hours
Tom July 1234 73.2
Mary July 1234 123
Mary July 3456 83

Then attach a pivot table to this table and you'll be able
to get any sort of summary - by project or by employee or
by month.

You may want a year column also if project are longer in
scope.

Good Luck

Mike

-----Original Message-----
I am trying to create a table that I can enter the number
Click to expand...
of hours an employee has worked on a particular project
(either weekly or monthy) and then list the total hours of
each individual project by all employees. Is there a
template already created for this, or are there any
suggestions on how to create one myself?
 
Top