Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolved!
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. :-(
Cheers!
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!