Duration Columns

Imagine that you run a Design firm and want to store and manage information about the time (days, hours, minutes) spent on creating a logo or advertisement. So, the Duration column will be helpful. It also may be taken as a basis for designers’ pay calculation.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

General Properties:

Properties defined by the column type:

Duration Options

Column Property

Description

Format

This property allows a user to specify a format in which the duration value will be represented. The following options are possible:

  • HH:MM - hours:minutes
  • HH:MM:SS - hours:minutes:seconds
  • :MM - :minutes
  • :MM:SS - :minutes:seconds
  • Smart – this format presupposes smart converting of entered duration data that provides a more convenient way of representation. For example, if a user enters “125 min” value, the system will convert it into 2.08 hours.
  • Days
  • Hours
  • Minutes
  • Seconds

* Decimal places

This property allows a user to specify the number of decimal places for a numeral value. Please note that this field is required.

Totals

This property allows a user to view the total for all column entries; select the check box if you want the Totals line to be present at the end of the table.

Zero values

When this property is unchecked, blank values are displayed instead of zero values. Also it affects the average calculation as zero and blank values are ignored. If the property is checked, zero values are visible, moreover, they are taken into account when the average is calculated.

Averages

This property allows a user to view the average for all column entries; select the check box if you want the Averages line to be present at the end of the table.

* - required property.

Advanced Options

Column Property

Description

Colorization

To draw users’ attention to some duration values, you can colorize them. The colorization is based on the conditions whether a value is less than an indicated number. Also, a color of an alternative value can be specified in the “otherwise” field. Moreover, you can apply Colorization in Formula-Duration columns. More details about the colorization you may read here >>

Help

When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: Timestamp Columns