How to Change Unit of Time in the Duration Field

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q191400
This article describes how to change the unit of time (minutes, hours, days, or weeks) duration is displayed in the Duration field.
More information
To change the unit of time displayed in the Duration field, follow thesesteps.

Use the Format Duration Macro

The Format Duration macro changes all durations for your project to thesame unit. The Format Duration macro is useful when you want to change allunit values to the same type. For example, if you have estimated durationsin hours and days, but want to display all of your durations in weeks, youcan run the Format Duration macro and change all of the durations displayedin hours and days to weeks.

If you are converting a smaller unit to a larger unit, it is possible thatrounding errors may occur. For example, if you are converting 15 minutes todays, the result is 0.03125 days. Because Microsoft Project only displaysdurations to two decimal places, it would round this result to 0.03 days.If you then converted 0.03 days back to minutes, the result would be 14.4minutes. But because Microsoft Project does not display partial minutes, itwould round the duration down to 14 minutes, instead of the original 15minutes.

To use the Format Duration macro, follow these steps:

Note: The Format_Duration macro is not included with Project 2010 and later.

  1. On the Tools menu, point to Macro and click Macros.
  2. In the Macro Name list, click Format_Duration.
  3. Click Run.
  4. In the Microsoft Project dialog box, type the duration unit in which you want all of the durations to be displayed: m for minutes, h for hours, d for days, or w for weeks.

Change the Units for the Project Summary Task

If the Project Summary task is displayed, the FormatDuration macro may not change the units for it. To do this, follow these steps:

  1. Click to select the duration of the Project Summary task.
  2. On the Edit menu, point to Clear, and click All.

Article ID: 191400 - Last Review: 03/26/2013 00:32:00 - Revision: 2.0

Microsoft Project 98 Standard Edition, Microsoft Office Project Professional 2003, Microsoft Office Project Professional 2007, Microsoft Office Project Standard 2003, Microsoft Office Project Standard 2007, Microsoft Project 2000 Standard Edition, Microsoft Project 2002 Professional Edition, Microsoft Project 2002 Standard Edition

  • kbhowto KB191400