Forum Discussion
Splitting Employee Punches by Factory Shift
Im trying to split my employee punches by shift time (7-3, 3-11, 11-7) but formula below is giving me more than 8 hours for some shifts which doesnt make sense. What needs to be updated so that this ...
As for how to adjust your existing formula, I think you have to limit the number of hours to 8 for the shift.
So a List.Max({ 0, List.Min({your existing formula,8}) } ) for example.