Welcome to PMConnection


· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites

Related Books 1
The Self-Driving Project: Using Artificial Intelligence to Deliver Project Success

Citizen Development: The Handbook for Creators and Change Makers
A Guide to the Project Management Body of Knowledge: PMBOK 7th Edition 2021

NEW for 2021: PMP Project Management Professional Exam Study Guide
Microsoft Project Step by Step

Microsoft Project 2019

Managing Enterprise Projects: Using Project Online and Microsoft Project Server 2019

MS Project: Automatically Change ALL Duration Units in Microsoft Project
Posted on Monday, November 12 @ 21:42:47 EST by webadmin

PMConnection Articles

Within MS Project, it is possible to use the following units for establishing durations:

  • Minutes (min)
  • Hours (hr)
  • Days (day)
  • Weeks (wk)
  • Months (mon)
Here is the scenario

You have a schedule with multiple tasks. For whatever reason, you have different units for the durations. Some are shown in Hours, some are shown in Days and perhaps one is in Weeks. You would like them all to be displayed in days.


You could go through your entire schedule and manually change them, but there is an easier way!

Within your schedule, click on >Tools, >Macro, >Macros. You will see the following box:


Highlight Format_Duration and click Run.

Another box will appear that allows you to choose the unit.


Select Days, then click on OK.


You will notice that all your Duration Units are now in Days!!!

You may find this book helpful: 
Ultimate Study Guide: Foundations Microsoft Project 2013

Related Links
· More about PMConnection Articles
· News by webadmin

Most read story about PMConnection Articles:
300 Project Manager Interview Questions

Article Rating
Average Score: 4.62
Votes: 24

Please take a second and vote for this article:

Very Good


 Printer Friendly Printer Friendly

Associated Topics

PMConnection Articles

Copyright 2005-2022 PMConnection.com. All Rights Reserved.
http://www.pmconnection.com a
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.09 Seconds