calculating R & D hours in a project

Question

calculating R & D hours in a project

josephv (Mechanical)

(OP)

2 Jan 07 11:31

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 (Aerospace) · Answer 1 · 2007-01-02 12:55:00

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

TTFN

josephv (Mechanical) · Answer 2 · 2007-01-02 16:05:33

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 (Aerospace) · Answer 3 · 2007-01-02 22:20:12

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 (Mechanical) · Answer 4 · 2007-01-03 13:32:18

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

Joseph

Come Join Us!

Posting Guidelines

calculating R & D hours in a project