Solved

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

Posted on 2013-11-22
2
219 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

808 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