Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Pretty much in line with the provided solution.
Got a slightly different answer than the provided solution - but very close (presumably a rounding difference):
So a couple things fall out of this. You have to decide whether to translate to minutes before of after you add up. Not a big deal, I made the opposite choice from the solution.
Far more interesting is that the datediff() function has two properties I had not really thought about:
The experiment with datediff() is included in the attached WF and image inside the spoiler.
ow im somewhat attuned to multirow formula haha no need to use join tool tho
I'll echo what others said about the time not matching.
Really enjoyed that one! I'm off by a minute, but looks like I'm not the only one...