Thread: Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem)
View Single Post
 
Old 01-19-2016, 02:24 AM
stormrider2230 stormrider2230 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jan 2016
Posts: 4
stormrider2230 is on a distinguished road
Default Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem)
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
File Type: xlsx Duty_Rooster_sample.xlsx (16.3 KB, 45 views)
Reply With Quote