Setup


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. 





Form Display


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
Seconds
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






View


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


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. 




Workflow


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 typesFor example, send an action to remind a user 60 days before a Formula field that has a date type format. 





Widgets


Process Breakdown


Use a Duration field as the Breakdown value of a Process Breakdown widgetFor 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. 



Import


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.