Duration Formulas
Create formulas using system duration fields or custom text fields with duration values in them.
e.g Original estimate * hourly rate.
Requirements:
One "Text Field (single line)" custom field to store your results.
As a user, you must make sure that the duration value in a text field being 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.)
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.
Enter your custom Formula Name. (It will be ‘Duration Add & Subtract’ by default.)
Select an existing system duration field or custom field of type 'text' to be added to or subtracted from. You can also create new fields if necessary from this section. These fields can only be of type text.
Select + or - to either add or subtract that duration.
Enter a duration value to add to or subtract from the field you selected in the previous step, or enter "@" to choose from system duration fields or custom text fields within your project. Note once again that in order for this calculation to work properly, if you select a custom text field here, it must take on one of the formats described in the Requirements at the top of this document.
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 of type text.
Select the desired result format. The default is “Mixed (e.g. 3d 2h 15m)”.
The "Save Formula" button saves the formula once you are finished editing it.
Duration Multiplier & Divider
Multiply or divide a duration from System duration fields, custom fields, or static numbers; with a number or another duration value.
It is important to note that duration multiplier & divider formulas calculate results in terms of hours only.
Enter your custom Formula Name. (It will be ‘Multiplier & Divider’ by default.)
Select an existing field. You can also create new fields if necessary from this section. These fields can be numeric, text or select.
Select to either multiply or divide.
Enter a static number to multiply or divide the value in the field you selected in step 2 by, or enter "@" to choose from another custom field within your project.
To use a negative duration place a "-" before the number.
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 of type numeric or text.
Select the result field format. The default is “Mixed (e.g. 3d 2h 15m)”.
The "Save" button saves the formula once you are finished editing it.
Duration Rollup
Sum up a single system duration field or custom field of type text with a duration value entered within it across a work item’s child issues and store the resulting value within the parent work item.
Enter your custom Formula Name (It will be ‘Rollup’ by default.)
Select the child issue type that the field to be rolled up resides within (Task, Sub-Task, Story, Bug, etc.)
Select the mathematical function you want to perform with this field. (Sum is the only option as of this moment.)
Select the parent issue type of the issue type that you selected in Step 2, and then 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 of type text.
The "Save Formula" button saves the formula once you are finished editing it.
Missing Fields?
If after adding a custom fields you wish to use to the project's Create and Edit Screens they should be available to be used in the formula as long as they are of a compatible custom field type. If the Custom fields do not appear as options when editing the formula then attempt to refresh the available custom fields by; navigating to the top right of the screen, clicking on the gear icon, and selecting the option "Refresh custom fields". Now the custom fields you've added should be available to use while editing your formulas.
Please write to our Support Desk with any questions you may have.