The Duration field is used to capture data related to units of time.
The Eligible unit(s) are: seconds, minutes, hours, days, weeks, months, and years.
Choose the units users will be able to select by checking the box corresponding to the unit.
Enforce value range by checking Min or Max and entering a value you want to enforce. Select the Units for value range to ensure you're enforcing a unit of value. For example, if you want to enforce 120 minutes but are allowing someone to enter in hours, you force a user to enter a maximum of 2 hours.
On form display the value displayed to the user will be that largest eligible units chosen where the value will be at least one. If there is a remainder after the large eligible units are calculated and there are smaller eligible units chosen, the remainder will be displayed in those units. If there are not any smaller units to handle the remainder, the largest eligible units will be rounded. Below are some examples.
|Eligible Units||Value (eligible unit)||Value Displayed|
||10 (seconds)||10 seconds|
|Seconds||61 (seconds)||61 seconds|
|Minutes, Hours||1 (minute)||1 minute|
|Seconds||90 (seconds)||90 seconds|
|Minutes, Hours||90 (minutes)||1 hour 30 minutes|
|Seconds, Minutes, Hours||90 (minutes)||1 hour 30 minutes
|Hours, Days||1 (hour)||1 hour|
|Seconds, Minutes, Hours||91 (minutes)||1 hour 31 minutes|
|Hours, Days||91 (hours)||3 days 19 hours|
|Days, Weeks||91 (days)||13 weeks|
|Days||8 (days)||8 days|
|Days, Weeks||8 (days)||1 week 1 day|
|Days, Months||45 (days)||1 month 15 days|
To add a Duration field to the Default view, navigate to Setup, click the default view you want in Default columns.
To add a Duration field to an existing view, Edit view.
Duration field(s) have their own section when editing a view. For each Duration field you can add all eligible units.
For a Duration field with a value of 1 hour, putting the duration units of seconds, minutes, hours, and days in a view would result in the view shown below.
Filter forms by a Duration field by Edit view, Add a filter, choosing a Duration field, and choosing to Limit to or Exclude values that are Less than, Greater than, or a Range.
Duration Field and Use in Formula Field
Duration fields can be used as inputs in a Formula field. The are two format types for Formula fields, Format (number) and Format (date).
Use the Format (number) format type when you want to use several Duration fields in a formula field to come up with a total duration and a unit. Consider the Formula field setup below that uses a free row type Table field that has a Duration field capturing estimated time in hours.
Use the Format (date) when you want to use a Date field and a Duration field to come up with a new date. Consider the Formula field setup below that adds a Duration field to a Date field to come up with a date in the future.
Action Trigger Conditions
Use Duration fields as action trigger conditions to send actions.
For example, you could use a Duration field as an action trigger condition to send an action to a user when the value of a Duration field tracking the Estimated Time to Complete Task is greater than 2 hours. The setup for this is below.
Date Field Reminders
Use Format (date) type Formula fields Date field reminders action types. For example, send an action to remind a user 60 days before a Formula field that has a date type format.
Use a Duration field as the Breakdown value of a Process Breakdown widget. For example, breakdown the status level or a project process by the estimated project hours tracked by a Duration field.
Use a Duration field and the Process Sum widget to display outstanding invoice time on open projects.
To import into the Duration field you should include the unit of the value you want to import. If you do not specify a unit on import, the default unit that will be used for the value you are importing will be seconds.
For example, consider the following:
If I want to import data into this process with a duration unit of minutes, my import spreadsheet would look like:
The result of this import would be:
The units that you can import are: seconds, minutes, hours, days, weeks, months, years.