Microsoft KB Archive/43621

From BetaArchive Wiki

PRJ: Duration/Work Values Changed When Exporting


The information in this article applies to:

  • Microsoft Project for Windows, versions 1.0, 3.0, 3.0a, 4.0
  • Microsoft Project for the Macintosh, versions 1.1, 3.0, 4.0


When exporting project data to a non text-based format such as WKS, WK1 or XLS, duration values are exported based on the default work units or duration units.


For example, if the duration units are set to days, and two tasks are entered that have 10W and 5D durations, then upon export to the XLS format, the 10W task will show as 50 (5 days per week x 10 weeks) whereas the 5D task will show as 5.

Project exports duration and work units as numbers so that they can be useful in computations in spreadsheet applications.

Additional query words: 1.00 1.10 3.00

Keywords : kbinterop kbusage
Issue type : kbprb
Technology :

Last Reviewed: November 3, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.