Solved

How do I make Microsoft Excel 2010 Duration span dates according to resources

Posted on 2013-11-22
2
220 Views
Last Modified: 2013-12-19
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?
0
Comment
Question by:zonkerman
2 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 39671013
use MS Project!
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39689806
Assuming you are actually using MS Project rather than Excel:-

The duration is calculated using several factors and they all need to line up for the behaviour you are describing. For example:
- is the task type 'Fixed Duration' ? it should be fixed work or fix assignment
- is the 'Effort driven' tick box checked
- does the resource calendar match the task calendar (ie: same working times)
- is the 'scheduling ignores resource calendars' tick box unchecked

If all these are set correctly then try levelling the task and see if that works.

If not then post a copy of the file you have a problem with

Reg
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question