Duration fields in Airtable

Plan AvailabilityAll plan types
Required permissionsOwners/Creators - Can add, delete, duplicate, rename, and customize fields
Platform(s)Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

To add duration fields:

  1. Open your Airtable homepage.

  2. Create or open your preferred base.

  3. Add or edit a field.

  4. Search for and select Duration.

  5. Click the icon under the “Duration Format” section and select your preferred format.

  6. Click Create field.

Note

  • When formatting the duration field's output, fractional values round up to the next closest value.

  • For example, suppose you select h:mm formatting but input 0.50. In that case, the duration output will round up to 0:01 since 0.50 represents half of a second.

Supported duration fields formatting options:

  • h:mm: Hours and minutes, e.g. 1:23

  • h:mm:ss: Minutes and seconds, e.g. 3:45, or hours, minutes, and seconds, such as 1:23:40

  • h:mm:ss.s: Minutes, seconds, and deciseconds, e.g. 3:45.6, or hours, minutes, seconds, and deciseconds, such as 1:23:40.0

  • h:mm:ss.ss: Minutes, seconds, and centiseconds, e.g. 3:45.67, or hours, minutes, seconds, and centiseconds, such as 1:23:40.00

  • h:mm:ss.sss: Minutes, seconds, and milliseconds, e.g. 3:45.678, or hours, minutes, seconds, and milliseconds, such as 1:23:40.000

Note

  • You can also format numeric formulas, lookups, or rollup fields as durations.

  • For example, multiply a duration by a number or roll up the sum of a duration field from linked records.

To add computed field durations:

  1. Open your Airtable homepage.

  2. Create or open your preferred base.

  3. Add or edit a field.

  4. Search for and select Formula, Lookup, or Rollup.

  5. Click Formatting.

  6. Click the icons to select your preferred duration and duration format.

  7. Click Create field or Save.

Why does my duration field's value increase when I use it in a formula?

Duration fields store values in seconds, regardless of the format you select. To make up for this in your formula, divide by 60 to calculate in minutes, 3600 (60 * 60) for hours, etc.

Why is my duration field not showing as a valid option for the y-axis of my chart?

While duration fields are numeric, they are not valid options for the y-axis of a chart extension. You can use a formula field to re-process your duration into a plain number, then use that formula field as your y-axis. Here's an example formula to reformat your duration field in minutes {Duration field} / 60.