Forum Discussion

Copper Contributor

Sep 05, 2020

Shift distribution into excel to review overall Coverage

I was recently working on a spreadsheet to review the overall coverage where I entered the numbers manually by looking at shifts for each employee for the entire week. I was thinking of applying a fu...

Query.xlsx13 KB

excel

ikawaljeetsingh

Copper Contributor

Sep 05, 2020

Thank You Riny, I'm going to think and apply your suggested logic sometime over the weekend. However, I'll continue to look for other solution that others can provide/suggest. Although, I'm going to try the solution provided by Sergei (below).

Riny_van_Eekelen

Platinum Contributor

Sep 05, 2020

ikawaljeetsingh Just wondering if your example really reflects what you want/need. Now you count the time slots that are carried over from Monday to Tuesday as time slots on the Monday. In my view, when a shift starts on Monday 17:00 and ends 04:00 the next morning it should reflect 4 hours on Tuesday from 00:00 till 04:00. In other words, the early morning slots on a Monday come from shifts that started on the Sunday before and that ran over midnight. But perhaps I misunderstood your requirements.

ikawaljeetsingh
Copper Contributor
Sep 05, 2020
Yes Riny, you got it right. When a Monday's 17:00 shift ends at 04:00, it should reflect the 4 hours on Tuesday 00:00 till 04:00.
- Riny_van_Eekelen
  Platinum Contributor
  Sep 05, 2020
  ikawaljeetsingh So, in your example for the Monday, there should be nothing in the early morning time slots as the first shift on Monday starts 6:00 and there is no information on the Sunday before. But again, perhaps I misinterpret your example.