Duration Functions

Duration is represented as a number of milliseconds. To create a value or make sense of a value, you need one of the following functions to convert a string to a duration and vice versa.

You can add duration to a date or date/time value and treat the result as a new date/time, but only if it's a calendar duration. This does not work with work duration.

To understand why, let's consider you wanted to add 16 hours at a date or date/time. The result should be slightly less than a day later. However, when using work duration, adding 16 hours will result in a date at least 2 days later (maybe more, if it crosses a weekend), based on Jira's default 8h/day 5-day work week.

CALENDAR_DAYS

CALENDAR_DAYS(Duration)

Returns a number of calendar days represented by the duration value as a decimal number.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of calendar days. May return a fractional number of days.

Examples:

CALENDAR_DAYS(DURATION("10d")) → 10
CALENDAR_DAYS(DURATION("12h")) → 0.5

CALENDAR_HOURS

CALENDAR_HOURS(Duration)

Returns a number of hours represented by the duration value as a decimal number.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of hours. May return a fractional number of hours.

Examples:

CALENDAR_HOURS(DURATION("10d")) → 240
CALENDAR_HOURS(DURATION("12h 45m")) → 12.75

CALENDAR_MINUTES

CALENDAR_MINUTES(Duration)

Returns a number of minutes represented by the duration value as a decimal number.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of minutes. May return a fractional number of minutes.

Example:

CALENDAR_MINUTES(DURATION("3h")) → 180

CALENDAR_SECONDS

CALENDAR_SECONDS(Duration)

Returns a number of seconds represented by the duration value as a decimal number.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of calendar seconds. May return a fractional number of seconds.

Example:

CALENDAR_SECONDS(DURATION("1h")) → 3600

DURATION

DURATION(Text)

Converts a text representation of a calendar duration to a number.

This function ignores Jira's settings for work time, so DURATION("1w") = DURATION("7d") and DURATION("1d") = DURATION("24h").

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Duration in milliseconds.

Examples:

DURATION("1w 2d 3h 4m")
DURATION("3d")

FORMAT_DURATION

FORMAT_DURATION(Duration)

Converts duration value to the Jira format with numbers followed by symbols specifying the time unit.

Parameter	Type	Description
`Duration`	`Number/Each`	Duration value in number format.
→ Result	Text	Duration value converted to Jira Duration format (1d 3h 30m).

Example:

FORMAT_DURATION(DURATION("1w 1d")) → "1w 1d"

JIRA_DAYS

JIRA_DAYS(Duration)

Returns a number of work days in the specified duration according to Jira's settings.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of work days. (By default, one day is 8 hours.) May return a fractional number.

Example:

JIRA_DAYS(DURATION("24h")) → 3
JIRA_DAYS(DURATION("12h")) → 1.5

JIRA_DURATION

JIRA_DURATION(Text)

Converts a text representation of a Jira work duration to a number.

The specified time is work time, according to Jira's settings. With the default Jira settings, JIRA_DURATION("1w") = JIRA_DURATION("5d") and JIRA_DURATION("1d") = JIRA_DURATION("8h"). To use calendar time, use DURATION.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Duration in milliseconds.

Examples:

JIRA_DURATION("1w 2d 3h 4m")
JIRA_DURATION("3d")

JIRA_WEEKS

JIRA_WEEKS(Duration)

Returns a number of work weeks in the specified duration according to Jira's settings.

Parameter	Type	Description
`Duration`	`Text/Each`	Value expressed in Jira Duration format (1d 3h 30m).
→ Result	`Number`	Number of work days. (By default, one week is 5 work days.) May return a fractional number.

Example:

JIRA_WEEKS(JIRA_DURATION("10d")) → 2
JIRA_WEEKS(DURATION("5d")) → 3