Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Calculating Total Time Spent

Topic Labels: Formulas
432 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Reply 1

Hi Beth,

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

Screen Shot 2022-01-27 at 4.27.52 pm

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

Screen Shot 2022-01-27 at 4.28.42 pm

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

Screen Shot 2022-01-27 at 4.28.57 pm

Hope that helps!

Una