Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution
Fun challenge, pity that time info was not important as it was tricky to calculate Night and Day shifts.
Super Cool challenge!
The macro is a bit confusing on it's function.
The Time given was a confusion but it was a good exercise.
Unfortunately, since I have an older Alteryx, I couldn't export the macro, so in the attached solution I used the internal part of the macro :)