This is definitely possible in a couple of ways, depending on what works best for your workflow. With a little table restructuring you could do this with three tables in on base. The first table would track Dates:
The second table for would track individual phone calls (one field linking to the date and one field linking to the phone numbers table) with a duration for each call:
The third table would track each phone number and include a total duration of the call:
The Total Call Duration field is a Rollup field that sums up the duration of all the calls:
If you’d like to learn more about this kind of table structure I recommend reading our article on Joins tables.
Another possible workflow could be achieved using Airtable Automations to update an existing phone number record’s total call duration if it already exists in a table.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .