Tagged: Support outside USA
I’m trying to refine a Microsoft Project formula for converting durations to work periods. I’ve come up with a specific formula but I want to generalize it regardless of which task calendar is applied. Here’s what I’ve come up with so far….
IIf([Task Calendar]=” 5d 8h Standard”,Duration/480,Duration*(8/12)/480)
Here the 12 denominator is based on the fact that I’m using a 5d 12h calendar in addition to the 5d 8h Project Calendar. So I want to generalize the formula to convert Duration to Work Periods using a Number field.
TS-cd (Total Slack in calendar days)
5d 12h Standard
5d 8h Standard
You’ll note that similarly, the formula for TScd above is: ([Late Finish]-[Scheduled Finish]). That allows me to see “equivalent TS” regardless of which calendar is used.
Therefore, what formaula will generally apply to convert duration to work periods?
How have you solved this issue ?
The users of this era completely advanced and always prefer hi-tech product and services. Microsoft is such kind of brand which is a leader in the current scenario from the past many decades. It has more than 300 products in its pockets for the users. If the users have any kind of technical hiccups then they can have help from Microsoft office phone number +1-877-833-8252 where they will be assisted by our well qualified and professional engineers with a quick response
I am in Australia another country outside of the USA 16 hrs time zone diff, what is the local phone number here please. I do not wish to make an international call