We help IT Professionals succeed at work.
Get Started

How to best change resource working time after the start of the project

Last Modified: 2013-11-15

I'm managing a project which has been ongoing for some months now. A change in the organization is forcing me to make a change to the working hours of part of my resource pool as of a specified date in the future. How can I best achieve this without affecting tasks prior to this change?

Ive only been able to come up with 2 options to resolve this.

Option 1 would entail to:
- copy all the relevant resources (eg. john to John1), and assign the copies to a new working schedule
- split all the tasks  (technically make two tasks from one with a FS dependency between them) such that there there is a part before and one after the given date
- assign the newly created resources to the "after" tasks.

Option 2 would entail to write a VBA script to edit the working times for all the relevant resources and change their personal working calendar as of the date in question. This has a drawback insofar that swapping out resources becomes a bit more complicated.

I'd appreciate any thoughts you have on the topic.

Thanks for your help.
Thomas Vanparys, PMP
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE