Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Calculate the remaining hours of incomplete tasks

Avatar

Level 2

I want to calculate the sum of remaining hours of incomplete tasks inside project level custom form. Let me know if someone can help with this.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

It's not going to be possible to sum the hours of incomplete tasks at the project form level. You could work out the difference between planned and actual hours across the entire project, but this wont exclude completed tasks.

 

Your best bet here is to create a task report, filtered to incomplete tasks and grouped by project. You could then sum the planned hours, gicing you the sum of the remaining hours to complete.

 

Best Regards,

Rich.

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

 

It's not going to be possible to sum the hours of incomplete tasks at the project form level. You could work out the difference between planned and actual hours across the entire project, but this wont exclude completed tasks.

 

Your best bet here is to create a task report, filtered to incomplete tasks and grouped by project. You could then sum the planned hours, gicing you the sum of the remaining hours to complete.

 

Best Regards,

Rich.