In your “time table” (first field can be “date”), create a number/duration field for time tracking (I would use a number field) + 2 linked fields: one for selecting employee (only 1 allowed) and one for selecting the project (multiple allowed). That way, your employee can add time to multiple projects for the same time duration.
In the “projects” table, add a rollup field that takes the “sum(values)” for the linked field (linked to your “time table”). Here you can add conditions, eg, only rollup the time spend by employee x. If you don’t have to many of them, you can have 1 field per employee per project. Add a formula field to add everything so you can calculate the time spent over the total project.
Or, of course, you can also use a chart via the dashboard functionality to get the same info, but then you won’t be able to do some calculations (eg, hours per employee per project x hourly cost).
Thank you for your quick answer. I appreciated it.
I’ve put my question better detailed in a real example attached here.
I have projects that sometimes overlap each other, and during these days, the employee will distribute his 8 hours equally for each project.
I’m already doing what you want to achieve, but I’m using Integromat for automation and Toggl for time tracking, all alongside Airtable. I don’t know if this suits your needs, but let me explain the workflow in few words.
Toggl give me the chance to change the client or/and the project everytime I want, so the time tracking is not a problem at all. After that, with Integromat, I can watch at the end of the day / week all the time entries and then, by using Integromat, I can send them to specified Airtable fields.
Unfortunately, it’s not an 100% Airtable pure solution but I think it can help you.