Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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