Calculate the remaining hours of incomplete tasks | Community
Skip to main content
Level 2
May 6, 2024
Solved

Calculate the remaining hours of incomplete tasks

  • May 6, 2024
  • 1 reply
  • 445 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

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.

 

1 reply

Richard_Le_Community AdvisorAccepted solution
Community Advisor
May 7, 2024

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.