Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL time stamp difference between 2 fields

Michael Frahry
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 15, 2020

I need to calculate an "incident duration" between 2 fields.  I have access to the 2 fields, I am unsure how to calculate the minutes between

2 answers

1 vote
Carlos Garcia Navarro
Community Champion
October 15, 2020

Hi @Michael Frahry ,

There are a few apps that you could use for your use case. E.g., these two posts describe how to subtract the dates using 'Script runner', 'Automation for Jira' or 'JWT'(Jira Workflow Toolbox):

Script runner: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Scriptrunner-Find-the-time-difference-between-2-date-time-fields/qaq-p/639353

JWT/Automation for Jira: https://community.atlassian.com/t5/Jira-Software-questions/How-to-calculate-two-date-fields-and-show-the-difference-in-days/qaq-p/1373672

Are you in the Cloud or Server? You can check the marketplace to check the apps and to verify if they are supported in the Cloud and/or Server:

https://marketplace.atlassian.com/

0 votes
Inna Gordin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2020

Hi Michael, if you are running on Jira Server or Data Center, please take a look at Jira Misc Custom Fields (JMCF) - it's calculated fields - it will be super easy to calculate this fields using this app. This field will be searchable.

It is also much cheaper than workflow or scripting tools.

Note: I work for Innovalog, maker of JMCF. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events