Challenge #68: Elapsed Classroom Times

[Gauthier_B]

Spoiler

[Alekh]

Needed to do some funky formulas to get it working

Spoiler

[AntonioGonzales]

Solved!

An excellent exercise to learn how to manipulate HH:MM in Alteryx.

I spent a lot of time until I decided to create 2 fields with DateTime format. :-(

Spoiler

Cheers!

[AntonioGonzales]

Hi @alex,

Hope you are well!

I just want to thank you for your solution!

It is simple, didactic and elegant!

Ah! And I loved your recipe:

1) Pad beginning and end so that the contain 4 digits.
2) Convert to time format
3) DateTimeDiff to calculate time elapsed.
4) Remove unnecessary columns. 

I've learned a lot with everyone here!

Cheers!

[cadyb]

It took many formulas and there were some tricky ones in there! Good practice for date time formatting and parsing!

[Steven_Pocoroba2]

Thanks Joe.

[catarina_pimpao]

Spoiler

[RolandSchubert]

My solution

[121Brain-]

Took several attempts to work out formulas

[T_Willins]

My solution.  Minimized number of tools by nesting formulas in a single tool.