Challenge #68: Elapsed Classroom Times

[Mattpannuzzo]

My solution. 

Not the prettiest but it works. 

Spoiler

[mascarenhas_lucas]

Here's my solution for this challenge, it's quite similar the official soluction!

Spoiler

[daniel_ferreira]

Follow the solution attached...

[ponraj]

uploading my solution...

[StevenBetts]

I found this one intensely frustrating!

Spoiler

I kept calculating the elapsed times from the 12 hour times, post conversion, and ended up with a ton of negative values! Ended up hugely streamlining the workflow while trying to figure out what I was doing wrong though, so not all bad!

[AndyBate]

Complete

[mceleavey]

A nice puzzle. I see it caught out some people who forgot about the 24 hour conversion function.

Spoiler

I first padded the date to a standard format, then used the datetime tool on each date to convert to an alteryx format. I then calculated the difference using datetimediff() function and then converted the dates to 12 hour format using %I:mm and dropped the extra columns.

And @MarqueeCrew made a mistake! He is human!

Everyone give me your betting slips and I'll pay out accordingly.

[Wouter]

My solution:

Spoiler

[mickael_gest]

My solution :)