Calculating Remaining hours

Sean Wood

Hello all,

I have an SLA that is calculated based on the following:

• 9am is the start of the next day
• 1 day runs for 24 hours
• Issue SLA's start at the beginning of the next day
• SLA is a 2 day (48 hour) direction.

e.g. A Jira issues is created at 11am. The SLA for this issue will start from 9 am the next day

e.g. A jira issue is created at 7:20 am. The SLA will start from 9 am.

 

How can I calculate the remaining time within a day (give that a day starts and ends at 9 am) ?

Ultimately I am trying to add the remaining time within a day and add the SLA duration (2days) to provide a total duration.

 

Using Automation to do the above.

Hope this is clear. Any suggestions are greatly appreciated.

 

 

Bill Sheboy

Hi @Sean Wood 

I believe if you sketch out your algorithm, you can do this with the built-in date/time functions.  Perhaps something like this:

• if created date/time's time value <= 0900 then
  • calculate the difference between now and 2 days from created at 0900

{{now.diff(issue.created.toStartOfDay.plusDays(2).plusHours(9))}}

• else
  • calculate the difference between created and 3 days from created at 0900

{{now.diff(issue.created.toStartOfDay.plusDays(3).plusHours(9))}}

Here is the documentation for date/time smart values to get you started: https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/

Please note: your approach seems to give people a "free pass" for issues created after 0900 up to the next day.  You may want to consider why SLA doesn't start until the next day.

Kind regards,
Bill