Converting work days to calendar days
in [Project]
|
Prev: cube building problem
Next: STDOLE2.TLB missing
From: Dale Howard [MVP] on 20 May 2010 14:05 FLCivilPE -- Create a custom Base calendar called 7-Day Work Week and set the working schedule for 8:00 AM - 12:00 PM and 1:00 PM - 5:00 PM for every day of the week including Saturday and Sunday. Do not include any company holidays on this calendar. When you create your custom field, use one of the available Duration fields such as Duration 1, for example. When you write the formula in the custom field, instead of using the DateDiff function, use the ProjDateDiff function instead. Write your formula using this function as follows: ProjDateDiff([Start], [Finish], "7-Day Work Week") After creating the custom field and formula, if necessary, press the F9 function key to recalculate your project. Hope this helps. -- Dale A. Howard [MVP] VP of Educational Services msProjectExperts http://www.msprojectexperts.com http://www.projectserverexperts.com "We write the books on Project Server" "FLCivilPE" <FLCivilPE.4b9p1b(a)DoNotSpam.com> wrote in message news:FLCivilPE.4b9p1b(a)DoNotSpam.com... > > I am attempting to use the DateDiff Function to do this. I figured-out > how to enter the start and finish dates. I'm not so sure what it is > asking for with the interval, firstdayofweek, and firstweekofyear. > > DateDiff( interval, date1, date2, firstdayofweek, firstweekofyear ) > > > -- > FLCivilPE > ------------------------------------------------------------------------ > FLCivilPE's Profile: http://forums.techarena.in/members/222556.htm > View this thread: http://forums.techarena.in/microsoft-project/773756.htm > > http://forums.techarena.in >
From: FLCivilPE on 20 May 2010 15:02
Thank you everyone. I was able to get the calendar durations shown on my project. I appreciate all your help. -- FLCivilPE ------------------------------------------------------------------------ FLCivilPE's Profile: http://forums.techarena.in/members/222556.htm View this thread: http://forums.techarena.in/microsoft-project/773756.htm http://forums.techarena.in |