Duration data types represent a period of time measured in hours, minutes, and/or seconds.
This prototype might be outdated due to global component updates. Please refer to the link under ‘Setting Options’ for an updated version of the shared components.
The user can set the column data type to ‘Duration’ by accessing the ‘Data Type Options’ in the columns header menu. Depending on whether there are existing values or not, and if they are valid duration values, the outcomes will vary:
If there are valid duration values, the system will convert them to duration types. For example, ‘120’ might become ‘2:00’ if interpreted as total minutes. If there are no valid duration values, the system will discard the existing values and default to an empty cell.
The following is an interactive representation of the various options that users can set for this type:
Duration Type Options
Depending on the duration format configuration, an empty cell will provide a placeholder format indicator such as ‘h:mm’ when the cell is in an active state. Depending on the format, the user might input a value using the exact format or in the unit values of minutes or seconds. For example, ‘240’ will be formatted as ‘4:00.’
Users can filter ‘duration’ data type columns with the same options as ‘Number’ data type, and it also allows natural language expressions to be used, such as 'greater than 2 hours.
Users can group ‘duration’ data types columns by different duration units such as hours, minutes, or seconds. Users can also apply group by ranges, with the same control used for number types.
Group by Ranges Control
A control to define range duration is introduced as part of this spec. It consists of two select input controls that define both the minimum and maximum time units in which the system will represent duration. So, for example, given a duration of 5400 seconds, where the maximum is hours, and the minimum is minutes, the system will represent the value in the cell as ‘1h 30m’. If the maximum is also set to hours, then 1.5h should show, allowing users to select single unit formats.
Both the minimum and maximum fields will allow values depending on the state of the other. So, for example, if a minimum is set to hours, then a maximum value of minutes cannot be allowed.