Working on a report where I need to calculate Shift Hours which alternate.
For example: One shift is goes 2 weeks first week Sun. Wed and Thurs Second week Mon Tues Fri and Sat then runs again third week Sun. Wed and Thurs and fourth week Mon Tues Fri and Sat the hours are 7am-7pm hours to work are 10.5 hours a day. Then there is another shift that is opposite from the above. Then there are two other shifts that do the same as above but work from 7pm to 7am same 10.5 hours. Any help with this greatly appreciated. There is a field for each day In the database.