I ran a quick test based on how I think your base is set up, and I’m not getting an error. It correctly summarizes all of the durations for each project. Here’s how I set mine up:
My first table is Time Tracking. I don’t know what you’re using for your primary field, so I just put dummy text in there. The second field is a date field, used by the Time Tracking block to store the start time. The next field is a link field pointing to a Project table, and finally I have the Duration field where the time tracker puts the recorded time spent. I didn’t include any collaborators, as that doesn’t seem relevant to the necessary calculations.
After adding some time entries, I moved to the Project table and added a “Time Spent” field, which is a rollup, pointing to the entries from the Time Tracking table, collection from the Duration field, and applying SUM(values). This was then formatted to be a duration format (h:mm:ss). After saving, the proper results appeared, summarizing the recorded time for each project from the Time Tracking table.
Does that sound similar to what you’ve done?
