Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Project 2013 auto schedule duration

Posted on 2014-12-22
2
Medium Priority
?
318 Views
Last Modified: 2014-12-22
I am a bit confused on how MS Project calculates the duration for the auto schedule for a summary task. Attached is the snapshot of my tasks. For the summary task, it summarizes as 20.38 days from 1/19 to 2/16. But the duration for all the tasks adds up to 16 hrs. I was expecting 2 days or 16 hrs for the duration for the summary task.
Capture.JPG
0
Comment
Question by:leblanc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 2000 total points
ID: 40513811
DURATION is the measurement, in calendar units, between a start point and a completion point, but MSP (and most PM software) ignore non-work days when calculating duration.

So, if something starts January 19, and completes on February 16

Then "elapsed duration" is the days
 19, 20, 21, 22, 23, 24, 25, 26, 27, 28 29, 30 , 31
 +
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16
 +
3 hours

for "duration" remove Saturdays/Sundays and then
 19, 20, 21, 22, 23,   26, 27, 28 29, 30
 +
   2, 3, 4, 5, 6,   9, 10, 11, 12, 13
 +
3 hours
= 20.38 Days

For example, let's say we had  3 tasks, each takes 1 hour. They ALL can be conducted in parallel.
|---------| task 1
|---------| task 2
|---------| task 3

A summary of those tasks is  1 hour
|---------| summary
|---------| task 1
|---------| task 2
|---------| task 3

IF those tasks cannot be done in parallel then the summary duration is much larger:
|-----------------------------| summary
|---------| task 1
          |---------| task 2
                    |---------| task 3

Open in new window

You CANNOT simply add durations to arrive at the duration of a summary task, you MUST consider the span between start and end.
not-16-hours.png
0
 
LVL 49

Assisted Solution

by:PortletPaul
PortletPaul earned 2000 total points
ID: 40513873
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

715 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