Help with man/months

[Lisa]

Hello! I need help to organize the working time spent by each employee
on projects.
I have many projects going on, staring at different dates, and each
employee can work on 0/N projects, for # months.
I built three tables: Projects, Employees, Manmonths
Manmonths contains: project_id, empl_id and number of months.
WHen I ask for a report, I would like to see if a man is working on
too many projects, e.g. is working for more than 12 months per year.
I see the trouble when, for example, I have two projects, both
starting on 1st December 2002, I say that the man works 3 months in
the first project and 4 months in the second one. I should find a way
to organize the man in such way that he works for 7 months, starting
from 1st december, ending 30 june.
When I ask how long did he work, in the interval 1st december 2002-1st
march 2002 I get 6 months!
I tried to figure out how to better manage the situation but I cannot
find a solution. Can anyone help me?
Thank you in advance

Elisabetta

[Dave O]

Hello, Elisabetta,
As an alternative, could you track the number of hours each man worked
on each project? A person could work on two different projects during
the same time frame if he is working part time. 8 hours on project A
and 8 hours on project B is a possibility, and could even occur on the
same day.

If you keep track of hours you could convert them to man-days,
man-weeks, man-months, etc.
{snip}

When I ask how long did he work, in the interval 1st december 2002-1st
march 2002 I get 6 months!