Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How do I Sum a column of duration

Topic Labels: Formulas
1541 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dustin-Yoe
4 - Data Explorer
4 - Data Explorer

I have a column of time duration.  How do I add all of those durations together?

Picture to show what I am trying to add up for a total time

1 Reply 1

You are thinking of Airtable as a spreadsheet rather than a database. It wouldn't make sense to sum all of the durations in the same table. Generally when groups of some quantity (or duration in your case) need to be summed, you would have a 2nd separate table and all of the records that have the quantity that require summing would be linked to a record in that 2nd table. You would then use a Roll Up field type to sum those quantities in the 2nd table.