none
Retrospective update of duration units RRS feed

  • Question

  • When you start a new project, the default "Duration is entered in" may be set to, say, days. So you enter 5 x tasks and they each have their duration listed in days. Then you change the "Duration is entered in" to hours. Now, when you enter your next task, it will have an 'hours' duration... BUT... it hasn't changed the tasks entered prior to that change to hours. Is there anyway to apply the changes to all existing tasks? (This comes about when one stakeholder wishes to see duration in Days, then another stakeholder wishes to see the duration in Hours. Thank you.
    Wednesday, July 6, 2016 1:35 AM

Answers

  • Heata_79,

    With older versions of Project (e.g. Project 2007 and earlier), Microsoft included a macro to do exactly what you want. Unfortunately that macro was dropped with the release of Project 2010. However, Rod Gill, our resident Project VBA expert, has graciously translated the old "format duration" code for the current versions of Project. See: http://www.project-systems.co.nz/VBA-Sample-Code/VBASampleFormatDuration.html.

    Hope this helps.

    John

    Wednesday, July 6, 2016 2:45 AM

All replies

  • Heata_79,

    With older versions of Project (e.g. Project 2007 and earlier), Microsoft included a macro to do exactly what you want. Unfortunately that macro was dropped with the release of Project 2010. However, Rod Gill, our resident Project VBA expert, has graciously translated the old "format duration" code for the current versions of Project. See: http://www.project-systems.co.nz/VBA-Sample-Code/VBASampleFormatDuration.html.

    Hope this helps.

    John

    Wednesday, July 6, 2016 2:45 AM
  • Thanks so much John, greatly appreciated.
    Thursday, July 7, 2016 12:14 AM
  • Heata_79,

    You're welcome and thanks for the feedback.

    John

    Thursday, July 7, 2016 1:54 AM