Duration Formulas

Requirements:

• One "Text Field (single line)" custom field to store your results.

• Single line text field supported for calculations. As a user, you must make sure that the entered duration value used for calculation has *w, *d, *h, or *m ( representing weeks, days, hours and minutes - where * can be any number. For examples: 4d, 5h 30m, 60m, and 3w.) appended to the duration number. 

Duration Add and Subtract

Add or Subtract two duration numbers together from System duration fields, custom fields, or static numbers to create a new duration.

1. Enter your custom Formula Name.

2. Select an existing duration field to be summated to. You can also create new fields if necessary from this section. These fields can only be text.

3. Select + or - to either add or subtract that duration.

4. Enter in a duration amount to sum to the field you selected or enter "@" to choose from custom duration fields within your project.

5. Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can only be text.

6. Select the time. The default is “Mixed (e.g. 3d 2h 15m)”.

7. The "Save Formula" button saves the formula once you are finished editing it.

Open

Duration Multiplier & Divider

Multiply or divide a duration from System duration fields, custom fields, or static numbers; with a number or another duration field.

1. Enter your custom Formula Name.

2. Select an existing duration field. You can also create new fields if necessary from this section. These fields can be numeric, text or select.

3. Select either multiply or divide.

4. Enter in a duration amount to multiply or divide the field you selected or enter "@" to choose from another custom duration field within your project.

   1. To use a negative duration place a "-" before the number.

5. Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can be numeric or text.

6. Select the time. The default is “Mixed (e.g. 3d 2h 15m)”.

7. The "Save Formula" button saves the formula once you are finished editing it.

     It is important to note that duration multiplier & divider formulas calculate results in terms of hours only. 

Open

Sub-Task Rollup to Issue

Sum up a single duration field from your sub-task custom field and store the results in the parent issue.

1. Enter your custom Formula Name.

2. Select the custom Sub-Task field you want to roll up into the parent issue. You can also create new fields if necessary from this section. These fields can only be text.

3. Select the mathematical function you want to perform with this field.

4. Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can only be text.

5. The "Save Formula" button saves the formula once you are finished editing it.

Issue Rollup to Epic

Sum up a single duration field from your issue custom fields and store the result in an Epic.

1. Enter your custom Formula Name.

2. Select the custom issue field you want to roll up into the Epic issue. You can also create new fields if necessary from this section. These fields can only be text.

3. Select the mathematical function you want to perform on the field.

4. Select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can only be text.

5. The "Save Formula" button saves the formula once you are finished editing it.