zonkerman
asked on
How do I make Microsoft Excel 2010 Duration span dates according to resources
Hello,
I am using Microsoft Excel 2010 and am having a problem with the Duration property reacting to my resources. For example, if I have a person with only 50% of their time for a project and the duration is at 16 hours the date calculation should span out to 4 days (4hours a day would take 4 days to add up to 16). But instead, it keeps just adding up to 2 days. So January 5 start date for 16 hours shows it will be done on January 6 but it should show it can't be done till 4 days later (January 9) because the person assigned can only work half time.
What do I need to do to make the end date add up the way I want it to?
I am using Microsoft Excel 2010 and am having a problem with the Duration property reacting to my resources. For example, if I have a person with only 50% of their time for a project and the duration is at 16 hours the date calculation should span out to 4 days (4hours a day would take 4 days to add up to 16). But instead, it keeps just adding up to 2 days. So January 5 start date for 16 hours shows it will be done on January 6 but it should show it can't be done till 4 days later (January 9) because the person assigned can only work half time.
What do I need to do to make the end date add up the way I want it to?
use MS Project!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.