Forum Discussion
Date Time - matching criteria and summing time
Hi guys, Hoping to get some help on how to work out the following: I have 2 tables: Table A - Consists of where employees are meant to be working (facility) and the start datetime and end da...
In the demo file is a suggestion for 3 employees. The formula works with VLOOKUP and can easily be adapted for hundreds of employees.
OliverScheurich hey thanks so much for your help! This works however there is some further complex logic that isnt picked up correctly 😞 I.e. if the same person works a split shift say 08:00-12:00 in SE and 12:00-16:30 in S.
They take sick leave 1 hour during SE shift and 1 during S shift. Using the excel you provided, this isnt picked up correctly 😞
You are welcome. Attached a suggestion for the new scenario where the same person has multiple unavailability entries.
- Thanks again! I will test and let you know how I go 🙂