Pull remaining Planned Hours on Project Report | Community
Skip to main content
K
Kasey-Gagne
Level 5
April 11, 2025
Question

Pull remaining Planned Hours on Project Report

  • April 11, 2025
  • 3 replies
  • 793 views

I am looking to pull a project report that shows the total remaining hours on a project for tasks that have not yet been completed. I was playing around with Completed Hours but that doesn't seem to solve it. Anyone else doing something similar?

3 replies

Lyndsy-Denk
Community Advisor
Lyndsy-DenkCommunity Advisor
Community Advisor
April 11, 2025

Hi, Kasey. I think you'll be better served by a task report. There might be a way to gather a collection of task hours in a project report, but a task report is going to be closer to the data you need.

    K
    Kasey-GagneAuthor
    Level 5
    April 11, 2025

    Thank you for the quick response! The issue is that we need to have this at a project report level that we show to our exec leadership team. They do not want to see things at a more granular level (tasks). The hope was to show projects with there % complete and the remaining hours left to be completed on the project rather than only being able to show the total Planned Hours or Completed Hours. 

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    April 11, 2025

     

    Hi @kasey-gagne,

     

    Although it might be more than you need, I invite you to consider our AFA Burn List solution which tracks Rates, Hours and Hour Costs at the Total, Portfolio, Program, and Project level.

     

    In particular, the far-right section of this screenshot shows the Remaining Approved Hours, Hours Cost, and Cost %; and if Costs are not (yet) important to you, we could tailor a version for you that removes the Cost columns and instead includes columns for:

     

    • Project % Complete
    • Forecast Hours %,
    • Scope Creep Hours
    • Scope Creep Hours %
    • Actual Hours %
    • Remaining Hours $
    • Actual Hours % minus Project % Complete
    • Actual Hours % / Project % Complete

     

    If you think this might be a fit, I'd be happy to chat further via doug.denhoed@atappstore.com

     

    Regards,

    Doug 

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      July 29, 2025

      @kasey-gagne Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

      Kautuk Sahni
      M
      MattLe3
      August 1, 2025

      I'm trying to do something similar. I don't want to reinvent the wheel since I have an existing Issues report leadership really likes. On the report I can create columns for the resolve project original planned hours, planned hours, and actual hours. But if I ask the report to calculate the difference between planned hours and actual hours, I get nothing.  Basically - this doesn't work: {resolveProject:workRequired} - {resolveProject:actualWorkRequired} even though I have columns for each of those values separately... so the report can see that data... just can't do math? 

      Terms & ConditionsAccessibility statement

      Loading footer...