Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Difference between two date/time fields, rounding to 1/2 hour.

I have two date/time picker fields for time to start and finish something.  I want another field that delivers the result of the difference between the two fields, rounded to half hour.  In other words, if the difference between the two fields is 4 hours and 15 minutes, I want the result to show, 4.5 hours.  Then I will subtract time for break.  

 

Can I do this with smartvalues.  I have looked at this https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Automation-for-Jira-Comparing-two-date-fields/qaq-p/1076853

but have not found what I need.

1 answer

0 votes

@Tracy Miller -

Hi Tracy:

In our env (Jira Software/JSM Data Center), we uses ScriptRunner for Jira add-on creating scripted field to do exactly what you are trying to accomplish.  After the scripted field is created, then we added the field to the project's Issue View screen.

Take a look at the add-on.  In my opinion, this add-on is a must have and it is a features-riched tool -

https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=cloud&tab=overview

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

631 views 5 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you