Is it possible to add task duration column to resource usage sheet? RRS feed

  • Question

  • Greetings,

    I would like to add task duration column to resource usage sheet (in list of available columns I found only  duration 1-10) if it's anyhow possible. By using filters I left only one type of resource in resource usage sheet and now I would like to have task duration column next to regular work.

    My goal is to have in one place resource name, regular work, task duration, start and finish columns.

    Thanks in advance,


    Wednesday, April 10, 2013 10:24 AM

All replies

  • Hi,

    Your goal is readily achieved in task Usage view.


    Wednesday, April 10, 2013 7:10 PM
  • tpd_1,

    Jan provided the simplest approach (i.e. use Task Usage instead of Resource Usage view), but if for some reason you want to use the Resource Usage view, you can get task duration copied to one of the extra assignment duration fields (e.g. Duration1) either by doing it manually or with a macro. For the macro approach, go to the MVP website at,, and take a look at FAQ 37 - custom fields in views. You will need to modify the code to change the fields.


    Wednesday, April 10, 2013 7:50 PM