Forums

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

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

Tracy Miller April 9, 2021

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
Joseph Chung Yin
Community Champion
April 9, 2021

@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
AUG Leaders

Atlassian Community Events