Duration when a different Task calendar apply

[Al Martin]

I have a schedule that some tasks required different calendar. For Example A
have a task a duration of 211 days working with the standard calendar 8 Hrs
per day 5 days per week. When I apply the new calendar in this case 20 hrs
per day 6 days per week Project schedule the work correctly; however the
duration still shows 211 days.
I want the duration to show the correct number of days which it would be
about 84.4 days.
In the Microsoft Office Assistance: Understading Calendars in Microsoft
Project 2002, page 4 of 5 tells you "to consider matching the calendar
settings to the working tim on the Calendar tab in the Options dialog box
(Tools menu), when this procedures are followed it fixes the Duration now it
displays 84.4 days, but the duration for the rest of the schedule get
affected too.
Is there any way to match the setting just for one task so it can display
the right duration??
Any help is highly appreciated.
Thank You!
Using Project 2003

 

[JulieS]

Hi Al,

A workaround that *may* give you what you need:
Add a custom text field (Text1, Text2 etc.)
Add the formula:
(ProjDateDiff([Start],[Finish],"yourtaskcalendarname"))/1200 & " days"

(Replace the "yourtaskcalendarname" with the base calendar showing 20 hours
per day, 6 days per week.)

This will show the difference between the Start and Finish of the tasks in
minutes and by multiplying by 1200 (60 minutes per hour times 20 hours per
day) will show you the "days" based upon the task calendar.

Hope this helps. Let us know how you get along.

Julie

 

[Steve House [Project MVP]]

Project tracks all durations in hours (okay, 1/10 minutes to be precise). A
"day" is defined as X number of hours so when you enter a duration as being
"3 days" for example, what is actually stored is X*3 hours. There is only
one global definition of a "standard day" and it applies to all tasks. The
working time calendar, on the other hand, shows how many minutes in the day
as measured by the rsising and settiing of the sun count for towards
duration. If I were to define "Hours per day" as 4 hours and had a task
scheduled to run from Monday 8am until Monday 5pm, that task's duration is 8
hours and would show 8/4 or "2 days" in the duration column even though it's
just one day according to the calendar on the wall because we have defined
each 4 hour segment of work as counting for 1 standard work day. So in your
case, 84.4 days is NOT the correct duration because when converted to
working hours it won't work out to be the right value.