How to create automation for due date to be in business hours

[Aryeh Schwob]

I am creating an automation for when an issue is transitioned to a new status it gets assigned a due date of for example 5 hours. I'm using smart date of {{now.PlusBusinessHours(5)}}

How do I set our business hours in Jira to 8am-5pm which will make the issue if assigned at 4:30pm have a due date of the next business day at 12:30pm?

Thank you!

[Mark Segall · Accepted solution]

Hi @Aryeh Schwob - Calculating Business Hours is going to be tricky because Jira Business Days are statically set to M-F 9:00 - 6:00.  If it's even possible, you would need to have a complex calculation based upon Days, factoring in weekends.

Is this a JSM project by chance?  If so, you could make use of SLAs because they allow custom calendars (not to mention exclusion days for holidays) which would do all of this dynamically.

[Aryeh Schwob]

Hi @Mark Segall 

9-6 can work too, its a Jira Work Management project. For now it will be easier to work with a 9-6 than to figure out a workaround.

Is there Documentation available for for how JIra statically calculates business days and hours?

Thank you!

[Mark Segall]

Take a look at THIS QUESTION that I answered previously.  It shows how you can convert business days into hours.

[Aryeh Schwob]

There is another issue that I ran into in that the duedate field only accepts dd/mm/yyyy and I'm trying to give it hours as the due date. Is there a field for that or do I have to create a custom field to show a due hour?

Again the project is a Jira work management project.

Thank you

[Mark Segall]

Correct, Due Date is a date only field so if you need to capture down to a specific time, you'll need to replace with a custom date/time field.

[Kateryna_v_SaaSJet_]

Hi @Aryeh Schwob 

If you are not against using third-party add-ons, then the following solution can be implemented with the SLA Time and Report for Jira add-on:
1) Create a calendar according to your schedule, considering holidays and holidays.

2) Set up a new SLA configuration according to the created calendar.
Select the Issue Created to Start condition, for Stop - all closing or resolving statuses, and put all others to Reset SLA.
Set the SLA goal to 5 hours and an action – change the priority to critical.

Thus, when the status of the ticket changes, SLA will be restarted each time and start counting a new 5 hours until the issue is resolved. It will be calculated exclusively within the working hours of your calendar. When the issue is closed, SLA will also stop counting.

I hope this helps you.