# Calculating Actual Duration from Actual Work • ### Question

• Hi everyone,

Please advise of how Project calculates Actual Duration from the known Actual Work by using the Scheduling Formula Work = Duration * Units.

For example:

• If there is a 5-day fixed units task Mo - Fri  with 2 full-time resources R1 and R2 assigned  to it.
• Resource R2 has a non-working Wednesdays set thought its personal calendar
• After resources are assigned to the task, Project re-calculates task's Duration from 5d to 6 days ( to account for 1 non-working day of R2),  and Work as 80h (40h per resource)

Now I enter %Work Complete values for resources: 60% for R1  and 20% for R2 that Project translates into Actual Work values: 24h for R1, and 8h for R2

Project calculates Actual Duration  as 2 days .

Please let me know of how it doe it.

Thank you,

Alex

Tuesday, October 25, 2016 11:53 PM

• Alex,

If R1 and R2 have completed 60% and 20% respectively, that means they have completed a total of 32 hrs (actual).

Assuming each resource's maximum work hours/day is 8 hours then 16 hours will be total actual work per day for both the resources. Now 32 hrs (16*2) is completed it means 2 days of actual duration is displayed.

You may check Task Usage and Resource Usage views by adding actual work, actual duration and %work completed columns for more clarity. Regards,

Sudhir

Wednesday, October 26, 2016 4:08 AM

### All replies

• Alex,

If R1 and R2 have completed 60% and 20% respectively, that means they have completed a total of 32 hrs (actual).

Assuming each resource's maximum work hours/day is 8 hours then 16 hours will be total actual work per day for both the resources. Now 32 hrs (16*2) is completed it means 2 days of actual duration is displayed.

You may check Task Usage and Resource Usage views by adding actual work, actual duration and %work completed columns for more clarity. Regards,

Sudhir

Wednesday, October 26, 2016 4:08 AM
• Hi Sudhir,

So basically Actual Duration = Actual Work / Units = 32h / 200% = 2d

Thank you,

Alex

Wednesday, November 2, 2016 12:12 AM