Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MS Project task duration vs work calculation

MS Project task duration vs work calculation

MS Project task duration vs work calculation

I am trying to setup a design schedule in MS Project-- The issues i've run into is that after I establish the precedence diagram/schedule and assign time to each activity(in days), and then resources to each activity, that MS project applies the resource cost(hourly rate) to the entire activity duration.  I want to be able to limit the amount of time or work that an activity takes but still maintain the activity duration etc.  Anybody have some pointers?

RE: MS Project task duration vs work calculation

I don't understand.  If you entered the actual work values, MSP should use those instead of the duration.  


RE: MS Project task duration vs work calculation

Good point-  The file I am working with was originally established as an effort drive file-- That created a problem for me in that it altered the duration of my schedule based on resource loading-- I then turned ED off, but am still having some problems.  I will start over with a scratch file

RE: MS Project task duration vs work calculation

By default, task types are set to Fixed Units and when you simply assign a resource, by default they are assigned at 100%.  So with these two variables in place, say you set up a task with 5 day duration and assign a resource.  The tool automatically calculates the Work for that task to be 40 hours.
Given the scenario that you described, here is what I would recommend:  I'm making the assumption that you have some tasks with more than one resource assigned.

-From Gantt Chart, Insert 2 columns, Effort Driven and Type
-Change the Effort Driven to No for all tasks
-Change Type to Fixed Duration for all tasks
-Now got to the Task Usage View (if only one resource is assigned per task, you can stay in the Gantt Chart view)
-Insert the Column Work
-You can now modify the Work for each resource per task to align with the effort that will actually be required to complete the task

With Type being set to Fixed Duration, when you modify the Work variable, your durations will remain the same.

Hope this helps!

J Black

RE: MS Project task duration vs work calculation

Not sure this will help, but when I had a similar problem, I found an answer by searching this forum: e-duration. When I set the duration to edays (elapsed days) and checked "estimated", I was able to spread the work over the expected number of days to complete the task, but it appears the duration will still vary (not fixed) according to the completion date I enter when that task is done. You just type "edays" in the duration field where msproject wants to put "days".

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close