Re: How do I Sum a column of duration

456 0
Showing results for 
Search instead for 
Did you mean: 
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.