How can I summarize the individual times to a total

Yaenz · July 13, 2022, 9:23am

Hi you SeaTablers,

I have the following problem. I do a lookup on the times table and get individual records (marked in red). I let the times be displayed (green). How can I summarize the individual times to a total (blue)?

Thanks for your help Yaenz

rdb · July 13, 2022, 9:57am

Please use a roll-up function in the link formula column. Summary method should be sum.

cdb · July 13, 2022, 10:18am

Hey Yaenz,
here is how I would do this:

save the time in a duration column and not a text or value column !!!

then use the link formular with the rollup to summarize the time.

with this setup you get this result.

Probably you have to change the format of the column

Best regards
Christoph

Yaenz · July 13, 2022, 1:40pm

Ohhhh Christoph,
Thanks a lot, this finally works fine.

Thanks Jens