Calculating a duration

[clifton]

In the planning phase of a project, duration for a task is a function of the
number of units that need to flow through that task and the capacity for that
task. I want the duration field to be calculated from a quantity and
capacity field. My planning buckets are in weeks.

I added two number columns for quanitity and capacity. I use a formula in
the duration column. The only time the duration is correct is when the
duration in the schedule tab is to minutes. This seems to be the default and
I can't seem to override the results. Changing duration and work units to
weeks doesn't yield the correct answer. Any suggestions?

 

[Jack Dahlgren]

A "day" in project has 480 minutes. A week has 2400 minutes. You need to
take that into account.

If you post the formula it will be easier to debug it.

-Jack Dahlgren

 

[Rod Gill]

Project stores all durations and work values as minutes so to get hours
divide by 60.

Note that Project's main duration field (that drives Gantt bar length etc)
cannot be calculated. To set it you will need to copy/paste or use VBA.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[clifton]

Rod and Jack - Thank you for your feedback! Clifton