how to get the difference between the created and resolution dates by only business work.

[Admin]

Hello, 

In our company, we want to automate the calculation of resolution time in business days. (without weekends, and local free days).

the diff function give us the total duration and not business work.

issue.created.diff(issue.resolutiondate) -> (exp: 3 days 18 hours 40 minutes 15 secondes)

I tried to manipulate the code and mines days , plus business days bit it seems that the format of the result of diff function does not support that.

we have a cloud jira service managemant instance.

So please, we need help to achieve this .

FTITI Walid

[Tessa Tuteleers]

Hey @Admin , 

There is a syntax to calculate the difference in business days, however, then you will change the value you calculate with to days, and you lose the hour / minute / second data. 

{{issue.created.diff(issue.resolved).businessDays}} 

If you really need this information as well you could try some advanced calculations ( count difference in days > count difference in business days > substract previous results (then you know how many non-business days you had > count total difference in time > substract amount of non business days)

Hope this helps!

- Tessa

[John Funk]

@Admin  - Please reply inline with this thread so users can follow the conversation. 

What exactly about Tessa's solution does not work for you? Please give an actual use case with values. 

[Admin]

Hello @Tessa Tuteleers , thank you for response but that does not help me.

As i mention I tried already the advanced calculation by the diff function result's format not compatible with arithmatic operations when triying to retrieve non business days.  also We d'ont have 'businesshour' statemant to use and we have only businessdays that will make us loosing the precision with hours .

Regards, 

Walid FTITI