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.

Attached Files

Duty_Rooster_sample.xlsx (13.8 KB, 16 views)