I have a duty rooster that calculates working hours and divides them to 6-14, 14-22, 22-06.



Now, I would like to include hours worked on weekend (Saturday, Sunday)and hollidays.

Problem is, i.e. Friday night shift will go from 23.00 to 07.00 which means, 7 hours will actually be worked on Saturday.

I tried to change the formula to calculate how many hours were worked on Saturday, from midnight on, and add it to the end of table, but failed.

Please help.

Attached Files

Duty_Rooster_sample.xlsx (16.3 KB, 45 views)