We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #312: Hours, Minutes and Seconds

8 - Asteroid

Solution attached

5 - Atom

Enjoyed a good practice with the formula Tool on this one.

Spoiler
1. I used a select tool first to extract just the 'Chat Time' Column.
2. Parsed Chat time through three DateTime tool to extract three field from Chat Time for Hours, Minutes and Seconds.
3. Joined using join multiple so I could use the Hours, Minutes and Seconds with one Formula Tool.
4. On the formula tool used Formula: IF LEFT([Hour],1)=='0' THEN RIGHT([Hour],1) ELSE [Hour] ENDIF on the Hour, Minutes and Seconds field while substituting the Hours with Minutes and Seconds on subsequent formula to remove leading '0'.
5. Used another set of 3 formula's on a new Field name mew Chat Time: IF [Hour]=="0" THEN "" ELSE [Hour] + " Hours " ENDIF. Same formula used again for minutes and seconds.
6. Use Select tool to display only the Chat Time and New Chat Time fields.
8 - Asteroid

Here is my solution

Spoiler

8 - Asteroid
Spoiler

8 - Asteroid
Spoiler

8 - Asteroid

My solution attached.

Spoiler

17 - Castor

Solution

Sapna Gupta
7 - Meteor

See my solution!

8 - Asteroid
Spoiler

A neat time conversion challenge, thank you!

8 - Asteroid

Challenge Completed. Thanks for the fun Challenge