Forum Discussion
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...
- Thank You @Ramiz, I tested the solution provided by you. It seems to be distributing the hours after 00:00 into the same day than the next day.
Then it would make more sense to start your day from 00:00 and end it at 23:59
Let's say one worker had a shift from 22:00 to 04:00 then from 22:00-23:59 goes to this day and the remainder goes to the next day.
the formula would be much easier.
Best of luck
