calculating R & D hours in a project 1

[josephv]

Hello,

Happy 2007!

As you may know many governments give tax credits for R & D hours in a project.

Not all the hours in a task or a project are R & D.

We would like to calculate how many hours were spent doing R & D in a particular project. Some of the tasks qualify as R & D and some do not.

Is there a way to "flag" the tasks that are R & D so that we can get the sum of all our R & D hours?

Thanks,

Joseph

 

[IRstuff]

Why can't you add a text column that flags your R&D tasks and the filter on that flag?

TTFN

 

[josephv]

Thank you IRstuff, this works perfectly.

One more question, once you have the filter is there a way to automatically add up all hours in the work column in MS Project?

cheers,

Joseph

 

[IRstuff]

Wel,, the cheap date is to copy the filtered data into Excel and sum it.

A more algorithmic solution is to use yet another field and customize it to report the cost for those items that you want, e.g., if(text1="a", cost, 0), then set the rollups for that column to sum.

TTFN

 

[josephv]

Many thanks IRstuff, your advice works great and is valued.

Joseph