Show actual duration of completed projects in a project report | Community
Skip to main content
CarolCaruso
CarolCaruso
Level 2
January 14, 2025
Question

Show actual duration of completed projects in a project report

  • January 14, 2025
  • 2 replies
  • 1172 views

Hello! I'm trying to create a project report that shows actual duration of projects.  One column is pulling the template duration, but I also want to show in a separate column the duration the project ACTUALLY took. Taking the actual start date and add up the actual completion date and show what that duration is (keep in mind, we have our schedule set up not to include weekends and holidays so it's not as straightforward as adding the days between the two dates). This will then show me a comparison to what the project SHOULD have started vs when it did and then how long is actually took.  Ultimately, I want to show two things: 1) are our templates set up accurately for the duration needed and 2) we are allocating enough time, but our projects are starting too late; therefore we're always late getting them done. Warning: I do not understand text mode well at all. HA! 

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
January 14, 2025

Hi Carol - Does the native field Actual Duration not work for your calculation? This should factor in how many days start to finish the project took basing the calculation on your Actual Start Date and Actual Completion Date of the project  - with your project schedule in mind. 

 

 

 

CarolCaruso
CarolCarusoAuthor
Level 2
January 15, 2025

@kelliegardner Thank you for reaching out.  It is not working.  I get empty fields.  I'm assuming it's because we currently are not logging our hours/time for each task; therefore I'm looking for something that will show the duration between the actual start date (the day the job's status is switched to Current) to when the status switches to complete.

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
September 1, 2025

@carolcaruso Hi there, just checking in. Were you able to get this resolved? If one of the replies above helped, even if it didn’t fully solve the issue but pointed you in the right direction, marking it as accepted can still guide others who may face a similar question. And if you discovered another way to fix it, sharing your approach would be a big help to the community. Your follow-up not only closes the loop but also ensures others benefit from your experience. Thanks again for being part of the conversation!

Kautuk Sahni
Terms & ConditionsAccessibility statement

Loading footer...