Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 21, 2021 04:26 AM
I have the following initial situation
The opening hours of my business are defined from Monday to Saturday and vary in length. Furthermore, more than 10 people work in my company, with whom I have to cover the opening hours. This means that each employee has different working hours per weekday. These working hours differ from employee to employee. So the absences of my employees are not calculated in days but in hours.
E.g.:
Employee 1: Monday 8 hours, Tuesday off, Wednesday 8.5 hours, etc.
Employee 2: Monday 9 hours, Tuesday 7.5 hours, Wednesday off, etc.
What I would like to achieve now:
Is this feasible? If so how?
Dec 21, 2021 08:31 AM
Hi there. Yes, I don’t see any problem with that and there are a few ways of how do make this possible. You could create a form, in which employees are selecting the date and times. This is then populating a “requested dates” table. They would also select themselves in that form, so that they are automatically linked to a separate table in which you can then do the calculation (100 - rolled up requested hours).
Does that make sense?