Challenge #312: Hours, Minutes and Seconds

[chiomaisaiah]

Spoiler

[NicoleJohnson]

Solved two ways! The long way, and the "one tool solution" way. 😁

Spoiler

The long way uses some of the traditional parsing tools to split the time into 3 parts, filter out 0 time, and apply the Hours/Minutes/Seconds labels before concatenating back together.

The "one tool solution" way, on the other hand, uses some nested formulas to strip out the time components (as long as they are not 0), string them together, and then remove any extra/unnecessary spaces.

Here's the one-tool formula I ended up using!

TrimLeft(
Replace(
If IsEmpty(TrimLeft(left([Chat Time],2),"0")) Then Null() Else TrimLeft(left([Chat Time],2),"0") + " Hours" Endif

+ " "
+ If IsEmpty(TrimLeft(Substring([Chat Time],3,2),"0")) Then Null() Else TrimLeft(Substring([Chat Time],3,2),"0") + " Minutes" Endif

+ " "
+ If IsEmpty(TrimLeft(Right([Chat Time],2),"0")) Then Null() Else TrimLeft(Right([Chat Time],2),"0") + " Seconds" Endif
," "," ")
)

Cheers!

NJ

[MJ]

No need for that 2nd input of lookup values :)

Spoiler

[Michael_Draper]

Took a shot! Probably a better way to do it, but I 

Spoiler

converted string to number and back to string to get rid of leading zeros

Spoiler

[G_Thompson]

Here's my answer!

[VizChic]

First time back in Alteryx for a while, so starting off slow :)

[PangHC]

one formula tool, 

datetimeformat

regex_Replace to remove 00 and leading 0.

Spoiler

[RolandSchubert]

Spoiler

[JereJussila]

Spoiler

Had to give it a go also with Regex, capture groups to the rescue

[Powerhouse_21]

Spoiler