Quote:
|
I have a duty rooster that calculates working hours and divides them to 6-14, 14-22, 22-06.
|
What does that mean? Are those regular shifts? Are they paid for at differing rates? I suppose you want formulas to split the hours into these three "categories".
I can't make hide nor hair of your equations in rows 6-9. What is it you want to do exactly?
Are the times always integer hours?
Why does the roster span 10 days?
See attached as a kind of tear down/rebuild to perhaps rethink the idea. Nothing is in stone.