Forum Discussion
Counting worked hours in a timeslot
Hi All, Looking to calculate how many hours a person has worked within set of parameters to determine how many FTE there are available within three hour timeslots. So if column K and L have the ...
Strange, but it is so much easier working with day shifts. I can't help thinking I must be missing something simple!
=MAPλ(startDayShift, endDayShift,
LAMBDA(s, e,
LET(
slot, DROP(Slot_End,,-1),
end, SORT(HSTACK(e, slot), , , TRUE),
strt, SORT(HSTACK(s, slot), , , TRUE),
end - strt
)
)
)
I can't help thinking there's an elegant solution in there somewhere with FREQUENCY but the PM to AM shifts throws a wrench in that!