Calculating Total Time Spent

[Beth_Kocol]

I have a “All Completed Tasks” table that holds all of my completed ClickUp tasks - two of the columns are: Project Title and Total Time Tracked.

I have a second “2022 Projects” table that lists all of my projects for the year. I want a field/column in this table to calculate the total time spent on the project, based on the ClickUp tasks from the first table.

I know enough to have a Project Title field in the 2022 Projects table that would match the Project Title field in the All Complete Tasks table (which I think is necessary). But I can’t figure out how to do the calculation.

EXAMPLE
All Completed Tasks table may show:
ABC Project - 12 min
XYZ Project - 9 min
XYZ Project - 7 min
XYZ Project - 4 min
XYZ Project - 9 min
ABC Project - 11 min
ABC Project - 8 min

I would like for 2022 Projects to calculate:
ABC Project - 31 min
XYZ Project - 29 min

[AirtableBuilds_]

Hi Beth,

If you have your Task records linked to your Projects, for example:

Then you can go to your Projects table, and create a Roll-Up field, for example:

And voila you should get the result you are after :tada:

Hope that helps!

Una