Using airtable to track the time we spend on projects for billing purposes.
I am working on gathering data sets to review whether certain types of project are profitable. I have a field for duration (using the time tracking block and h:mm:ss format) which creates a record that is linked to the project record. Im looking for a way to roll up all the time tracked on one project from different collaborators into one field to see the overall time spent on a project.
I thought I could format it the same way we have our total revenue formatted Rollup > Payments > Payment Amount > SUM (values) but with the h:mm:ss format it just returns an error message.
I know I can view the overall time in a summary view when grouping/filtering views to certain projects but it would be ideal to have these numbers automatically added to the project records so that more fields can be used to calculate profitability.
Thanks in Advance!