Plan Availability | All plan types |
Required permissions | Owners/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) |
Adding duration fields in Airtable
To add duration fields:
Open your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Duration.
Click the ⌄ icon under the “Duration Format” section and select your preferred format.
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
Adding computed field durations in Airtable
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:
Open your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Formula, Lookup, or Rollup.
Click Formatting.
Click the ⌄ icons to select your preferred duration and duration format.
Click Create field or Save.
FAQs
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
.