Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAReally not sure sorry @CSmith16 - I'm not doing anything special other than using AMP. Perhaps just a difference in our systems?
@DataNath All good, I just wanted to get the exact output and use a Crew Macro to validate but it kept throwing errors because the sort order was incorrect. Either way I got the answer just had to do it a different way, thanks for the challenge though!
I wasn't sure what to do with people who worked Exactly 4 hours, but figured it out. Also likely could have calculated possible total shifts as part of the same workstream, but realized it after-the-fact.
Had a bit of an issue with the non-working days and rounding as my numbers were slightly off