Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAInteresting challenge.
My solution:
1. Formula Tool: PedLeft function to create consistency and comparability amongst the start/end times.
2. DateTime Tool: Convert string to date format following the DateTime Function documenation.
https://help.alteryx.com/20213/designer/datetime-functions
4. Formula Tool: IF statement to find if time exists for class and DateTimeDiff to compute elapsed time.
Took a while and to many formulas to solve this one.