edays


M

Miguel

How do I change days to edays, on the duration column, for summary tasks?
 
Ad

Advertisements

J

John

Miguel said:
How do I change days to edays, on the duration column, for summary tasks?
Miguel,
The Duration field of summary lines is calculated by Project and it will
always be in working time. You can however set up a spare field and
customize it with the following formula,
Text1=DateDiff("d",[Start],[Finish]) & "ed"

Be sure to check the option to "Use formula" for calculation for task
and group summary rows.

If you only want the summary lines to show edays, you will need to use a
simple VBA macro that utilizes the above formula.

Hope this helps.
John
Project MVP
 
Ad

Advertisements

D

DavidC

Hi,

What 'edays' represents of course, is time independent of holidays and
weekends, in other words seven day weeks. So why not set a calendar which is
seven day weeks, and no holidays, and set the summary task to use this
calendar. It will then calculate the duration between the start and finsh of
the summary task, based on the seven day calendar. I have found this
phenomena some years ago when I was challenged by a client on the difference
between the duration on the summary line and the durations of the underlying
tasks, which in this case could readily be seen.

Hope this gives some help.


Regards

DavidC
 

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