Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 18 views)
Reply With Quote
 



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 07:53 AM.


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