Display Elapsed Duration

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

Steve
Thu Apr 21 15:32:47 CDT 2005

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.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Copper" <Copper@discussions.microsoft.com> wrote in message
news:86F906EB-41D6-4F58-96E1-319E913BCDEA@microsoft.com...
>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
>
>
>

harisrashid2
Thu Apr 21 16:01:03 CDT 2005

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
-------



"Copper" wrote:

> 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
>
>
>

Copper
Fri Apr 22 14:39:03 CDT 2005

Thanks to Steve & Haris - both method work fine

"Copper" wrote:

> 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
>
>
>