Forums

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

How to calculate time in hours between two fields (date type) and display it in workload pie gadget?

Stanislav Platonov
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!
January 25, 2022

The main goal is getting sum of all the time that teams spend for the first respond:

Capture.PNGCapture1.PNG

 

We have two date type fields in our project "Created" and "Date of First Response".

Also we use JIRA Charting Plugin to get a "Date of First Response".

We need to calculate time in hours between this two fields "Duration time of First Response" since date "Created" till "Date of First Response".

For instance:

"Created": 12-05-2021 18:19

"Date of First Response": 12-05-2021 22:36

"Duration time of First Response": 12-05-2021 4h17m

1) How to calculate "Duration time of First Response" and get time in hours between two fields (date type)?

2) How to display the result of calculation in workload pie gadget by teams?

 

0 answers

Suggest an answer

Log in or Sign up to answer