Hi all!
I am currently working on a base in which our staff members will be able to fill out their weekly timesheets. I live in Canada and here the standard hours of work is set to 8 hours in a day and 40 hours in a week.
In our company, the standard hours of work for a week is set to 35 hours. Any worked time that goes between 70 and 80 at the end of each Pay Period (2 weeks) is put in a bank. I can't figure out how to properly sum those hours without creating an astronomical amount of fields so I need your help.
In my base (which is in French) I have 6 tables :
- Feuilles de temps (=Timesheets) which is linked to Pay Periods, People, Days and Projects
- Périodes de paie (=Pay Periods) which is linked to Timesheets, People, and Weeks
- Personnes (=People) which is linked to Timesheets and Pay Periods
- Semaines (=Weeks) which is linked to Pay Periods and Days
- Jours de la semaine (=Days) which is linked to Timesheets and Weeks
- Missions (=Projects) which is linked to Timesheets
Here's what I've done so far in order to sum the extra hours in a bank :
- In Pay Periods, I've created multiple fields to sum the hours worked by every team member (which is already a lot)in Week 1 and Week 2 of every Pay Periods. In that base, I have a formula field that calculates the number of hours to put in the employee's bank.
- In People, I've created a rollup field for each staff member to sum the hours that would need to be put in their respective bank of hours (=Banque d'heures).
Here's my question : considering my workflow, is there any way to sum the banked hours per staff member in one rollup field - let's say with some kind of complex formula - or do I have to create a rollup field for each staff member and use filters to collect the right data?
Here's the link to my base : https://airtable.com/appuLqZFtJovkCypN/shrutE7CHcPLqgUo4/tbl6Wcyyy9eAI35DW/viwKQInzYABBxm7wT
Best,
David