By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 858 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Help with man/months

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.