Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

summary to = actual no. of days?

Status
Not open for further replies.

alnewman

Mechanical
Jun 28, 2006
2
I've been requested to show the duration in total days (not working days).
example:
the project starts on May 15 and ends on June 15
summary equals 20 days, but need it to show 30 days in the summary.

Is this possible in a summary bar?
 
Replies continue below

Recommended for you

I'm new here, and a little discouraged. A couple of days and no answer to my seemingly simple question. I'm wondering if there's a morre active forum?

ps. for now, I'll keep task in units of DAYS, and Duration in units of WEEKS (decimal weeks that is). It seems to be the only way to represent the actual elapsed days of durations.
 
Why don't you change Saturdays and Sundays into working days. Go to "Tools" then " Change Working Time" Click on Sunday ,then select "nondefault working time". Do the same for Saturdays.That might solve your problem.
 
Seemed like a simple request!! But after an hours worth of research, this is the best I could come up with.

First off, I would not recommend changing the working time for the project calendar, this could impact all the other task dates in your project.

Here is what I did:

1. Create a new calendar (Tools, Change Working Time, New, Rename to calendar1, make all Saturdays and Sundays Non-Default Working Time-Click on the entire column, OK)
2. Insert Duration1 field
3. Customize Duration1 - Use this formula, also enable formula for summary task.
4. Duration1 will now calculate the total days between start and finish.


Hope this helps!

J Black

PS: I truely believe there is an easier way, but could not find it!!!
 
Sorry!! Here is the formula:
ProjDateDiff([Start],[Finish],"calendar1")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor