Prev: Autofilter
Next: Moving tasks order
From: JPD on 21 Apr 2010 17:56
I need to take a schedule and reduce all the total hours across the
board by 30% ... is there an easy way to do this??

in a panic trying to get proposal out....

Thanks,
J
From: Rod Gill on 21 Apr 2010 20:38
Hi Try:

Insert Work column or apply Work Table
Copy Work column to Excel
Use Replace to remove h for hours
Use formula to calculate new values copy paste back into Project Work
column.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




"JPD" <jdescant(a)gmail.com> wrote in message
news:0e11b41f-8197-4093-bd05-4beae27689a2(a)r27g2000yqn.googlegroups.com...
> I need to take a schedule and reduce all the total hours across the
> board by 30% ... is there an easy way to do this??
>
> in a panic trying to get proposal out....
>
> Thanks,
> J
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5048 (20100421) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5048 (20100421) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: Trevor Rabey on 21 Apr 2010 20:53
Insert a spare number field with a formula [Work]*(7/10) then copy and paste
the result into the Work field.
Of course, this will immediately change also the duration or the assignment
units depeneding on the task type and effort driven settings for each task.
You could set them all to Fixed Duration before the paste.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"JPD" <jdescant(a)gmail.com> wrote in message
news:0e11b41f-8197-4093-bd05-4beae27689a2(a)r27g2000yqn.googlegroups.com...
>I need to take a schedule and reduce all the total hours across the
> board by 30% ... is there an easy way to do this??
>
> in a panic trying to get proposal out....
>
> Thanks,
> J


 | 
Pages: 1
Prev: Autofilter
Next: Moving tasks order