How to calculate turn time from request entry date to project completion? | Community
Skip to main content
K
Kasey-Gagne
New Participant
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

R
Richard_Le_Accepted solution
New Participant
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
    New Participant
    April 27, 2022

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

    R
    Richard_Le_
    New Participant
    April 27, 2022

    No problem Kasey.

    This will only work on a Project report.

    ElenaDooley
    ElenaDooley
    New Participant
    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

      Terms & ConditionsAccessibility statement

      Loading footer...