Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI thought about doing it all in just a formula tool, but why waste all of the dev effort put into the Date Time Parse?
Lots of if!
I suspect my answer is a bit too brute force (due to my not yet knowing all of the datetime functions, but I got there. Thanks to Marquee Crew's Expect Equal tool, I found some problems along the way. And in fact, there are some negative elapsed times in the solution set (ahem!)
What I learned:
- Don't trust the first few records as proving the accuracy of your result
- Expect Equal is pretty awesome
- There should be universal time standards (enforceable by a long sentence at hard labour) so this sort of problem doesn't arise ever again
Your solution is so much simpler than mine - good lessons - thanks