Microsoft KB Archive/124031

{|
 * width="100%"|

Effort_Driven Calculates Incorrectly If Hours Greater Than 547

 * }

Q124031

kbprg kbcode

-

The information in this article applies to:


 * Microsoft Project for Windows, version 4.0

-

SYMPTOMS
The Effort_Driven scheduling macro does not function correctly for a work value greater than or equal to 547 hours. When you run this macro for a task that has a total amount of work greater than or equal to 547h, the results will be inconsistent.

NOTE: This problem does not occur in Microsoft Project for the Macintosh version 4.0.

CAUSE
This problem occurs because the variable for work is declared as type Integer, which means that the limit for the value of work is 32,767/60 or 546 hours (note that the integer value is divided by 60 because work is returned in minutes).

WORKAROUND
To work around this problem, follow the procedure below to declare nTaskWork at type Long:

 From the Tools menu, choose Macros, select the Effort_Driven macro and then choose Edit. From the Edit menu, choose Find, and search for the Variable Declarations section.  In the Variable Declarations section, change the following line Dim nTaskWork as Integer to: 

Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.

Additional query words: 547h

Keywords :

Issue type : kbbug

Technology : kbProjectSearch kbProject400