Converting work days to calendar days
in [Project]
|
Prev: cube building problem
Next: STDOLE2.TLB missing
From: FLCivilPE on 20 May 2010 11:20 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: Andrew Lavinsky on 20 May 2010 12:24 A couple of ways: 1) Take a spare number field and add the formula [Finish]-[Start] 2) Add a 7 day working calendar. Call it "7day" and then use this formula in a duration field: ProjDateDiff([Start],[Finish],"7day") Why do you need this, if I may ask? - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > 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 ) > > http://forums.techarena.in >
From: Jan De Messemaeker on 20 May 2010 13:06 Hi, Interval: the time unit you want, "m", "h", "d", "w" first and last day of week: only if you use "w". Never used that. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional +32 495 300 620 For availability check: http://users.online.be/prom-ade/Calendar.pdf "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 13:35 Thank you Andrew. That doesn't completely answer my question about how to complete the DateDiff fields (interval, date1, date2, firstdayofweek, firstweekofyear) Basically I have a schedule developed using a five day work week, but the client has requirements for meeting calendar durations. I just want to show the calendar durations for each task. -- 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: Andrew Lavinsky on 20 May 2010 14:01
Both of those formulas satisfy that requirement, no? - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > Thank you Andrew. That doesn't completely answer my question about > how to complete the DateDiff fields (interval, date1, date2, > firstdayofweek, firstweekofyear) > > Basically I have a schedule developed using a five day work week, but > the client has requirements for meeting calendar durations. I just > want to show the calendar durations for each task. > > http://forums.techarena.in > |