Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2014, 08:54 AM
ravl13 ravl13 is offline Inconsistent Duration column for the same date ranges Windows XP Inconsistent Duration column for the same date ranges Office 2007
Advanced Beginner
Inconsistent Duration column for the same date ranges
 
Join Date: Nov 2012
Posts: 50
ravl13 is on a distinguished road
Default Inconsistent Duration column for the same date ranges

Hi,

I've noticed that when I have task dates that are on Saturdays and Sundays, the Duration column in the project becomes inconsistent. I have a screenshot below

http://imgur.com/HXm28zU

We can see that in row 2 for the Project Management task, there is a duration of 190 days. But row 3 below it for the Project Manager task says a duration of 192 days. Clearly there's some kind of wonky calendar thing going on here whenever there's weekend days involved (it's consistent when the start and end dates are weekdays), but I don't know where calendar settings are stored. Where can I look for the configuration/setting that is causing this weirdness, and how do I apply consistent calendar settings across the entire project?

Reply With Quote
  #2  
Old 07-27-2014, 06:09 PM
JulieS JulieS is offline Inconsistent Duration column for the same date ranges Windows 7 64bit Inconsistent Duration column for the same date ranges Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The duration of a task is working time based upon the calendar in use. So, if you have resources assigned to tasks - the calendar in use is their calendar. On summary tasks the project calendar (set in Project Information) is used to calculate duration.

In the attached picture, the only task shows a longer duration than the single summary task. The resource assigned to the task has a calendar with Saturday marked as working days. Based upon the resource's calendar, there are 21 working days between July 28 and August 20 - counting Saturdays. However the project calendar only has working days Monday through Friday - so there are only 18 working days using that measure.

When dealing with resources with different calendar definitions, it may be more meaningful to stop talking about "duration" and start talking start and finish dates plus work.

I hope this helps.
Attached Images
File Type: jpg calendars.jpg (26.7 KB, 16 views)
Reply With Quote
  #3  
Old 07-28-2014, 08:09 AM
ravl13 ravl13 is offline Inconsistent Duration column for the same date ranges Windows XP Inconsistent Duration column for the same date ranges Office 2007
Advanced Beginner
Inconsistent Duration column for the same date ranges
 
Join Date: Nov 2012
Posts: 50
ravl13 is on a distinguished road
Default

The projects and resources are actually using the same "Standard" MS Project calendar. But the problem seems to arise from the fact that the subtasks are set to manually scheduled mode, while the task rows are automatically scheduled. Manually scheduled rows automatically include a start date of Sunday as a working day since you manually set that date (even though its not on the calendar), but the parent "automatic scheduled" row that changes to match the new start date does NOT include Sunday as a working day because it's not on the calendar.
Reply With Quote
  #4  
Old 07-28-2014, 05:16 PM
JulieS JulieS is offline Inconsistent Duration column for the same date ranges Windows 7 64bit Inconsistent Duration column for the same date ranges Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I agree with your statement. As shown in the picture I attached, it can also occur with autoscheduled tasks and differing calendars. Manually scheduled tasks can be entering with start and/or finish dates during what is usually non-working time.

My best suggestion is to use manual scheduled tasks only during early planning. I switch to autoscheduled well before I start assigning resources.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inconsistent Duration column for the same date ranges Inconsistent Calculated Column Formula Error amlevesq Excel 1 04-22-2014 11:53 AM
Inconsistent Duration column for the same date ranges Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Change Resource Time vs. Duration when Updating Work column lylel Project 3 07-23-2012 06:09 PM
remaining duration vs finish date ketanco Project 3 02-17-2012 02:24 PM
updating status date and actual duration ketanco Project 5 01-27-2012 07:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft