Work Days vs. Calendar Days

S

Sarah M-H

Our client is under contract to complete a project in 540
CALENDAR days.

Our project schedule, which is based on working 8 to 5, M-
F, calculates the project duration as 355 WORK days.

It would be nice if the duration included weekends so
that it showed up as 540 calendar days. Is this possible?
 
S

Steve House

No, because duration is related to work performed and work hours don't
happen on non-working time. In fact, the fundamental "textbook" definition
of duration is "the number of working time units between when a task begins
and when it ends" and non-working time is explicitly excluded. To show the
number of calendar days the displayed duration is equivalent to, you could
create a calculated field that subtracts the start dates from the finish
dates of the tasks and rolls up into the summary tasks, giving you two
columns in your table, one for true duration and the other for the elapsed
time.
 
S

Steve House

Followup to my previous message -- to display the elapsed days, in one of
the vacant number fields enter the formula

DateDiff("d",[Start],[Finish])

and in the formula definition specify "use formula" in the entry for summary
tasks and then add the field as a column to your task view tables.
 
S

Steve House

OOps - forgot to add 1 day in the formula previously (what can I say, it's
late!)

DateDiff("d",[Start],[Finish]) +1

Without the 1 it gives Mon thru Fri as 4 days, not 5.
 
S

Sarah M-H

Thanks for figuring out a solution of sorts. I know it's
not a true "duration," but it helps to be able to point
to a # that is consistent with the contract they are
bound to.

-----Original Message-----
Followup to my previous message -- to display the elapsed days, in one of
the vacant number fields enter the formula

DateDiff("d",[Start],[Finish])

and in the formula definition specify "use formula" in the entry for summary
tasks and then add the field as a column to your task view tables.

--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


Our client is under contract to complete a project in 540
CALENDAR days.

Our project schedule, which is based on working 8 to 5, M-
F, calculates the project duration as 355 WORK days.

It would be nice if the duration included weekends so
that it showed up as 540 calendar days. Is this
possible?


.
 
M

Mike

MUST BE A WAY, or atleast more simple work-around. Many people use MSProject as presentation tool, not just a scheduler. There should be a setting that allows the user to simply imput calendard days and automatically calculate calendar day durations. Everyday treated as 24-hours and there are no non-working days....

Is there someone else that has done this in the past?
 

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