troubleshooting Question

Crystal Report Calculating Shift Hours

Avatar of nobile00
nobile00 asked on
Crystal Reports
18 Comments1 Solution802 ViewsLast Modified:
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.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros