[SOLVED] Sum of all time values in airtable

[nuuzonessqnzvv]

Hi all,

I am using Airtable for my app (seen below).

If the user ‘Alex’ has multiple entries, I want to obtain the sum of the ‘Total Time’ column.
E.g. 2 entries in this table are 0:0:20 & 0:0:27, so sum of times should be 0:0:47 seconds.

So far I am able to display the value of the total time by counting through the airtable, (blocks see below).

But how can I show the sum of all the times??

Many thanks

[ioannis]

Hello @nuuzonessqnzvv
To build this you will need to add a variable to calculate the total. Every time the condition is true add the the value to the total.