Forums

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

automatically calculate issue creation to resolution

Ryu Shinei(劉臻瑩) June 27, 2025

I would like to automatically calculate the time elapsed from issue creation to resolution in Jira Service Management.
When the issue status changes to "Resolved", I want to calculate the time difference between the created time and the resolution date, and then store that in a custom text field in the format “X hours Y minutes” (e.g., “175 hours 45 minutes”).

Please tell me how to set up the automation rule in detail, including:

  • Trigger settings

  • Smart value syntax

  • How to prevent duplicate execution

  • How to format the output as human-readable (not decimal, but hours and minutes)

I’ve already created a custom field (text type) to store the result.

1 answer

0 votes
Marc - Devoteam
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.
June 27, 2025

Hi @Ryu Shinei(劉臻瑩) 

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. what type of project is this (e.g., company-managed, team-managed, etc.), 

2. images that show your complete rule.

3. images showing the details of any relevant actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. Explain where the issue is.

These questions are not for not willing to help, but to have community members understand on how automation works.

You should use smart values related to dates, ira-smart-values-date-and-time Date-difference 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events