Challenge #68: Elapsed Classroom Times

[MinaGO]

Spoiler

All in one tool! Spotted some problems in the original data so minorly cleaned before processing.

[JustinMatthews]

Spoiler

After learning a few of the time specifiers this became pretty simple.

[Natasha]

Used 3 formulas to get the answer, and then used two more to convert the answer to string as per output. I tried to wrap the last two formulas around my time calculations, but it didn't work in the same column for some reason. 

Spoiler

[rohanonline]

Here is my solution

[JoeM]

Solution posted!! I hit the formula tool hard this week ;)

[Natasha]

JoeM, thanks for another interesting solution! I learned something new again.

Realised that I didn't convert 24h to 12h before, so here is my updated solution.

[estherb47]

Here's my solution. Two approaches. One which is step by step, and one which does everything with long formulae in a formula tool

Spoiler

Spoiler

[estherb47]

Here's my solution. Two approaches. One which is step by step, and one which does everything with long formulae in a formula tool

Spoiler

Spoiler

[Garrett]

Wow that was unpleasant. Whatever happened to Alteryx requiring "no coding"?