How to auto calculate & display DURATION using Jira automation (issue/ task field)?

[Sasika Nanayakkara]

Data Type:    Duration

Entry Type:    Calculated

Description:    How to display duration in Jira tasking projects?  

The Duration field is the total span of active working time for a task. This is generally the amount of working time from the start to the finish of a task (business days).

How Calculated:   Duration of a task/issue will be calculated by counting the amount of active working time (business days) between the scheduled start and end of the task. This is generally the time from task start to finish, not counting time between split tasks or nonworking time.

Best Uses    In tasking projects, duration for task will be entered when I create the Jira plan. It is the span of time shown by the Gantt bars on the Gantt Chart.

Example    Chris is scheduled to work on the "Write proposal" task on Wednesday, Thursday, and Friday.
Jamie is scheduled to work on the "Write proposal" task on Wednesday and Thursday.

Sean is scheduled to work on the "Write proposal" task on the following Monday and Tuesday.

The working span of the "Write proposal" task, and therefore its duration, is five days (Wednesday, Thursday, Friday, Monday, and Tuesday).

WHAT’S THE SYNTAX TO CAPTURE & DISPLAY DURATION WITH JIRA AUTOMATION?  Details of the complete solution will be very much appreciated!

[Mark Segall]

Hi @Sasika Nanayakkara and welcome to the community!

You would want to use a smart value, similar to this:

{{issue.Target Start.diff(issue.Target End).businessDays}}

More info on date functions can be found here:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

[Bill Sheboy]

Hi @Sasika Nanayakkara -- Welcome to the Atlassian Community!

You noted this:

How Calculated:   Duration of a task/issue will be calculated by counting the amount of active working time (business days) between the scheduled start and end of the task. This is generally the time from task start to finish, not counting time between split tasks or nonworking time.

The difference you note between the "scheduled start and end" would be the scheduled working time, and not the actual active working time.  What to you need: the scheduled or actual active working time?  Whichever you need, please confirm the source fields of start/end contain what you expect and then you use the method described by @Mark Segall 

Kind regards,
Bill