
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2023 12:08 PM
Hello, I am having to add hours ("duration") to a field and outputting to a new field where a formula would be developed, however, I am not sure how to format the formula for the duration; here is my formula:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2023 12:43 PM
Juan,
Duration is stored in seconds, so if you want to add 30 hours, add 108,000. Also, make sure your field's formatting is set to Duration.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2023 12:43 PM
Juan,
Duration is stored in seconds, so if you want to add 30 hours, add 108,000. Also, make sure your field's formatting is set to Duration.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2023 01:03 PM
Hi, looks like you are putting the hours you want to add in curly brackets which Airtable sees as a field name. Try removing the brackets and just use the number 30.
