Forum Discussion
Solved
Measure to calculate working hours based on shift patterns
Hi, Hi, I have a pre-existing model with employee data, job data, shifts, shift patterns, annual leave etc etc. What i am trying to achieve is a measure to calculate the number of working hour...
for such a chaotic setup you should ditch the shift pattern approach and go with an actual shift calendar. For each employee list all shift start and shift end times.
Thank you for the responce, sorry but i do not understand what you mean.
If you meant a shift calendar listing each employee and their start/end times, day by day. This is not an option due to number of employees and number of shifts (each in their thousands).
If you meant one table listing each employee and start time and end time by when they started and ended that particular shift pattern. This we already have.
I am having trouble working out who should have worked how many hours on any given day. Think I may have to limit myself to monthly rather than daily or weekly.