How to calculate turn time from request entry date to project completion? | Community
Skip to main content
K
Kasey-Gagne
Level 5
April 25, 2022
Solved

How to calculate turn time from request entry date to project completion?

  • April 25, 2022
  • 2 replies
  • 1496 views

Hello! I am looking to build a report with a column that calculates the overall turn time from the Request Entry Date to the Resolve Project's Actual Completion Date - excluding weekends and holidays.

Any help is appreciated :)

Thank you!

Best answer by Richard_Le_

Hi Kasey,

Use the following text mode to calculate the turnaround time from request entry to project completion.

displayname=Turnaround TIme

textmode=true

valueexpression=ROUND(DIV(WORKMINUTESDIFF({convertedOpTaskEntryDate},{actualCompletionDate}),480),0)

valueformat=HTML

The expression looks at the number of working minutes between the two dates and divides the number of minutes by 480 which is the number of minutes in a standard 8 hour working day. This gives you the total number of days exluding any non working time such as weekends or holidays.

Best Regards,

Rich.

2 replies

ElenaDooley
ElenaDooley
Level 4
April 26, 2022

I have a project report that does just that! Try this text mode... I don't know how to exclude holidays, though.

displayname=Response Time Request Entry to Project Completion

textmode=true

valueexpression=WEEKDAYDIFF({convertedOpTaskEntryDate},{actualCompletionDate})

valueformat=HTML

    R
    Community Advisor
    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    April 26, 2022

    Hi Kasey,

    Use the following text mode to calculate the turnaround time from request entry to project completion.

    displayname=Turnaround TIme

    textmode=true

    valueexpression=ROUND(DIV(WORKMINUTESDIFF({convertedOpTaskEntryDate},{actualCompletionDate}),480),0)

    valueformat=HTML

    The expression looks at the number of working minutes between the two dates and divides the number of minutes by 480 which is the number of minutes in a standard 8 hour working day. This gives you the total number of days exluding any non working time such as weekends or holidays.

    Best Regards,

    Rich.

      K
      Kasey-GagneAuthor
      Level 5
      April 27, 2022

      Thank you so much, I will give this a try! Would this work best on a Project or Request report?

      K
      Kasey-GagneAuthor
      Level 5
      April 28, 2022

      Thank you, this works perfectly! Do you know if there is a way to also use text mode to display the original request's entry date on the report?

      Appreciate your help!! :)

      Terms & ConditionsAccessibility statement

      Loading footer...