How can duration be set for calendar days?

M

mrcog

I want "Duration" to reflect standard working days (Monday through Friday)
but the start to finish time period to be given in calendar days.

Can this be done?

Thanks
 
J

JulieS

Hi mrcog,

There is a work around using a custom duration field and a custom calendar.
Create a new calendar (Tools>Change Working Time). Copy the Standard
calendar, name it (I used 7Day) and make Saturdays & Sundays working days.
Then insert a custom duration field ([Duration1] for example) in the task
table. Choose Tools>Customize Fields and select the [Duration1] field.
Click the Formula... button and use the following formula:

ProjDateDiff([Start],[Finish],"7Day")

In the Customize fields dialog box, click the Use Formula option for the
task and group summary rows.

This will calculate the number of calendar days between the start of the
task and the finish of the task using the 7Day calendar. .

Hope this helps. Let us know how you get along.

Julie
 
S

Steve House [Project MVP]

Julie has given you a good workaround to dispay task elapsed times. By al
means use it for reports, etc, if that's what more senior management wants
to see but when developing the actual plan try to resist the temptation to
use elapsed time in lieu of duration. Duration is that portion of the
elapsed time where work can take place Assuming the standard calendar,
that's why the duratiuon of a task beginning Wednesday and ending the
following Tuesday is 5 days and not 7. According to the calendar no work
will happen, no progress achieved on Sat or Sun. So when you look at a task
that can begin Monday and will take 10 days of work to complete, your finish
date will be 10 working days plus how ever many nonworking days intervene
down the line. To develop an accurate schedule you really have to drop the
dates where work doesn't happen from the overall elapsed time.
 

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