Help

Calculating Total Time Spent

Topic Labels: Formulas
1891 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Beth_Kocol
4 - Data Explorer
4 - Data Explorer

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
AirtableBuilds_
5 - Automation Enthusiast
5 - Automation Enthusiast

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