Total Remaining Planned Hours at a project level summary

Hi Timothy,

This might be too simplistic, but perhaps you could create a calculated parameter at the Project level that deducts actual hours from planned hours.

Regards,

Doug

Hey Timothy,

I found a field on the project level called 'Completed Hours' but I can't figure out what exactly it pulls. Maybe @Kyna Baker - inactive‚ could help figure that out? I created a project report and added this field, but when I looked at a project, added a column to sum planned hours and grouped by task status, the completed task hours did not add up to the 'Completed Hours'. I do have a number of tasks that are in progress, so I'm wondering if there is a calculation used for some percentage of the in progress planned hours to add into the Completed hours.

If that field will work for you, you could create a calculated column in your report to subtract completed hours from planned hours.

Hope this helps!

Hi Sarah and Timothy,

Interesting question! So I just did some testing and here's what I'm seeing. I'm also asking for a more official answer as to what formally makes up a "completed" hour, but I thought I'd share what I learned in my testing.

I did a project report and added the "completed hours" field that you were referencing.

I added two projects to do some comparisons, one that was 100% done and one that had barely been started.

On the first line of the screenshot, the project that is complete has 9.5 planned hours associate to it, but in my project report it shows 10. I believe that this field auto rounds up, but I am confirming that! I'll let you know if I find out anything different.

On the second line, that project only has one task that is 75% complete, but that partially complete task has 2 planned hours on it. This is making me further certain that the completed hours field rounds up.

I then went in and changed the partially complete task to be only 25% complete and it changed the number of completed hours to 0 for the second line. Another test, by setting the task to be 50% complete, the completed hours in the report updated to 1 hour (of which, you'll remember there are 2 planned hours on the task, so 50% should equal 1 hour.)

So I'm fairly confident in saying that the completed hours round up based on the percentage of the tasks that are complete, but I'll let you know if I find out otherwise.

So, to take it to your original question, if you subtracted planned hours from completed hours you would get a number that is close, but not down to the half hour or hour based on how you mark tasks complete (if you do partial percentages or not).

I'll update with more details if I find out anything else.

Kyna