Hours

Just get the "as planned" version of your plan, before any updates were made to it, set the status date, select the tasks that should (ie were planned to) have started by the status date, and click the "Update as scheduled" button on the tracking toolbar. Then see Actual Work in the Tracking Table.
Also, in MSP2003 you can use the Analysis Toolbar to export the Cumulative Work, same thing.

Hi Trevor,

This is a good way of doing it, but when the plan contains 2000 activities this way is very time-consuming.

What I wish for is that have a column that can show me this all the time for each task and summery.

Any more ides?

Trevor’s solution is actually not so time consuming. Have the "as planned" programme in a seperate programme. Adjust the Status Date, get the hours as Trevor suggest and then copy/paste the whole column over in one go (requires the same order of ID, but that is easily done).

Anyway, formula for a customized field could be something along the lines of:
IIf([Status Date]>[Start];IIf([Status Date]>=[Finish];[Duration]/60;ProjDateDiff([Start];[Status Date])/60);0)

Regards,

Bo

Hi Bo,

This is exactly what I am looking for! Thank you!

When I am working with a lot activities I think this is a nice way of getting a good look for each activity.

I am not saying that the other way is bad; I just think this is easier.

Regards

Dan

I changed the formula a bit,

IIf([Status Date]>[Baseline Start];IIf([Status Date]>=[Baseline Finish];[Duration]/60;ProjDateDiff([Baseline Start];[Status Date])/60);0)

Now I can see the planned value up to status date

Thanks

Bo and Trevor

Regards

Dan