bulk changes working times
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Bulk changes to Working times

Bulk changes to Working times

resolvedResolved · Medium Priority · Version 2003

replyReply Fri 17 Oct 2008, 09:42Delegate Kevin said...

Kevin has attended:
Project Intro Intermediate course

Bulk changes to Working times

I have a number of projects that were set up with extended working times (8am to 7pm and 10 hrs working days). Resources were scheduled per day not per hour. These need to be changed to reflect an 8 hr day, 8am to 5pm. Is there any way of making the change in bulk, without having to delete and recreate each task?

For upcoming training course dates see: Pricing & availability

replyReply Mon 20 Oct 2008, 15:23Trainer Andrew said...

RE: Bulk changes to Working times

Hi Kevin

In principle it is possible to do this however before you make any changes you need to make a full back up of your files so that if you run into any problems you can revert to the original versions and start again. I also suggest you experiment with a small project that has only one or two tasks until you are happy with the steps you need to follow. Project 2003 only supports 1 undo and changes to the calendar aren't covered by undo at all.

The second thing to consider is that when a calendar's day is reduced Project carries any remaining work that falls on that day forward to the next day. So reducing a day from 10 to 8 hours means two hours from day one are now pushed forward to day 2. If all your days are reduced Project keeps on pushing remaining work forward ultimately delaying the end date of your Project.

Your next task will probably be to go through each task and correct their durations based on 8 hours per day rather than 10

I strongly suggest you try first on a project with one task to get a feel for how Project responds. I can offer a simple example which might help get you started.

Create a new blank project and create one task with a 5 day duration.

Go to the Tools menu and choose change working time. Select the columns for your working days and reduce each of their durations by one 2 hours.

Before you click on OK click on the options button

On the screen that appears set the default hours to reflect your new daily hours, set the weekly hours to the new weekly figure and modify the default start and finish times for tasks.

Click on OK (When you are happy with your tests you can click on set as default so that all your future projects are createed with the new calendar settings already applied)

Click on OK again and see what has happened to that five day task. You'll probably find the task bar has extended (as there is less room each day to do the task).

I hope this is helpful as a pointer to the things you will need to change. We can provide consultancy services if you require support whilst you work on applying the changes to your projects. Just let us know and we can supply further information.

Kind regards,

Andrew

 

Please browse our web site to find out more about
london-courses-ms-project-in and other Microsoft training courses.

Ms project tip:

Giving Someone a Gantt Chart Snapshot

To pass on a picture of a Gantt chart segment, choose the appropriate view, select the rows to be included, then click on the camera icon and select For Screen. The graphics image can be pasted into another document. (See Paste icon forn Project 2010)

View all MS Project hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard