Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 5

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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.

View solution in original post

6 Replies

Avatar

Level 5

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

Avatar

Correct answer by
Level 10

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.

Avatar

Level 5

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

Avatar

Level 10

No problem Kasey.

This will only work on a Project report.

Avatar

Level 5

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!! 🙂

Avatar

Level 10

HI Kasey,

Glad I could help.

You shouldn't need any text mode to display the original request's entry date in a project report. There is a field called 'Converted Issue Entry Date' available as a column natively within the report builder.

Best Regards,

Rich.