Challenge #312: Hours, Minutes and Seconds

[Qiu]

A solution to last week’s challenge can be found here.

On daily basis, call centers are handling customers requests using a chat feature. In parallel, their analysts are checking data to report on their operators performance.

A data analyst in a major call center was responsible to report on their numbers by the end of the day. He wants to convert the time format from "HH:MM:SS" to "Hours Minutes Seconds", and his boss does not want any unnecessary information in the output. So meaning, no leading zeros and attribute should be removed if it is zero.

Using the data sets provided create an output with the format that the data analyst needs.

[Aaron_Harter]

Right on time!

Spoiler

[atcodedog05]

Here is my take on it.

Spoiler

I am just solving this from muscle memory 😅. Since I had solved a similar usecase a while back😀

Thanks for the fun challenge @Qiu 

Cheers and Happy analyzing :)

[David-Carnes]

Even though this was a simple one, I still adhered to the principle of dumping or filtering out unneeded data as soon as possible.

Spoiler

[Blake]

How do clocks greet each other? 

Spoiler

They say hour are you doing?

Spoiler

[PatrickW_]

Alteryx: the time is now!

[joelmiller66]

Spoiler

[binuacs]

Spoiler

[TonyA]

There are a pile of ways of doing this. I think I can see what Qiu was looking for based on the format of the solution and his including a mapping table for the time units, so I tried to follow that.

Spoiler

[Watermark]

Feel like I was lazy and have too many tools, but I am pressed for time so just threw this together. 

Spoiler