Hi all,
I'm fairly new to Airtable formulas so not sure if this is actually possible.
I'm trying to create a base for employees to view leave balances and submit new requests.
I want to be able to show the hours used between the start date and end date but only the hours on working days excluding bank holidays. A working day would be 8 hours between 9am to 5pm.
If possible I'd also like to calculate that against a persons FTE % so if a person only works 4 hours per day the working hours would be from 8am to 12pm.
- Requested leave from the 2nd of September 9am to the 6th of September 5pm duration 40 hours.
- Requested leave on the 2nd of September from 9am to 11am the duration 2 hours.
- Requested leave who works 50% from the 2nd of September 9am to the 6th of September 5pm duration 20 hours.
I have had quite a few attempts now and have managed to get it to show 40 hours but the formula wasn't able to handle the partial hours on the same day.
Thanks in advance for any advice/help!
