Challenge #312: Hours, Minutes and Seconds

[fsnunes]

Not the most elegant solution, but the one I came up with.

[EW]

My solution:  

Spoiler

[spingili]

[ngqth]

Using Regex tool to solve.

Spoiler

[PhilipMannering]

Attached.

Also in the Python Tool,

[adriansteller]

I feel like there were ways to do this with fewer/more advanced tools and techniques but I went for simple! Look forward to checking out what others did.

Spoiler

[StephanieWillis]

My first weekly challenge solve!

Spoiler

 

 

[NiamhGillespie]

solution:

Spoiler

Not super efficient I could have probably done the conversion to hours/minutes/seconds it with a single multi field formula

[scoles0617]

My solution:

[Reesetrain2]

All,

Spoiler

I did not use Find/Replace!
I did use:
1 join, 2 Select, 1 Text to Column, 2 RecordID, 1 Filter, 1 Summarize Tool, 1 CrossTab, I Transpose, 1 Sort, 1 Formula

 -Cheers!

Matt