Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADefinitely didn't need so many steps but hey ho.
After giving my previous solution, using nested time addition (felt forced), I saw @mceleavey's solution using the mod function. His was more elegant, and great use of the mod function! Great challenge, lots learned.
Did several formulae in one formula tool... no doubt there is a far more efficient way to do this so I'll go back and look at some of the other solutions soon.