Display Elapsed Duration

C

Copper

I would like to display two columns for durations for a given task that is 8
working days.
The project uses the standard calendar, i.e., Saturdays and Sundays are not
working days.
For example:
Task A - Start: 3/18/05 8 working days duration Finish 3:29/05

Duration in Project displays 8 days.
How do I set up a field that will display the elaped duration of 11 days. I
have tried to use formulas for Duration 1 such as subtracting the start date
from the finish date but have had no luck.

I would like it to display as below:

Duration Duration1
8d 11d
 
S

Steve House [Project MVP]

Check out the DateDiff() function in Help. It gives you the time periods
between two dates. Careful what you use that computed elapsed time for -
99.9% of the time true duration instead of elapsed time is what you should
use to actually manage the project. With the rare exception of things like
unattended automated tests or concrete hardening time, progress on the
project will only occur when people are able to be scheduled to work on it,
hence the duration measument ignoring all non-working time.
 
H

Haris Rashid

hi,

MS Project provides the elapsed duration option. To assign the task an
elapsed duration, type an e before the time unit. For example, to assign an
elapsed duration of 3 days, type 3ed. Elapsed duration is the amount of time
that a task will take to finish, based on a 24-hour day and a 7-day week,
including holidays and other nonworking days. For example: emin = elapsed
minute, ehr = elapsed hour, eday = elapsed day, ewk = elapsed week.

You can also represent elapsed duration as follows:
Click TOOLS, select Customize and click fields. In the customize fields
dialog box, select the number fields. For say NUMBER1 field, select the
formula button. Define the formula as [Finish]-[Start]. This should give you
the duration.

Regards,

Haris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top