Challenge #312: Hours, Minutes and Seconds

[Carolyn]

Solution attached

[NoelCarson]

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.

[JoachimCaronTIL]

Here is my solution

Spoiler

[alexhenson]

Spoiler

[François_Rs]

Spoiler

[sreekanthac]

My solution attached.

Spoiler

[grazitti_sapna]

Solution

[HannahLaughton]

See my solution!

[olga_strubbe]

Spoiler

A neat time conversion challenge, thank you!

[Kusk]

Challenge Completed. Thanks for the fun Challenge