Challenge #312: Hours, Minutes and Seconds

[jfissel]

Spoiler

Not the most efficient route...

[Pilsner]

My solution:

Spoiler

 

[Bennu]

Easy one tool solution @Qiu ! 😃

Although maybe I cheated (you tell me..) since I ignored the 2nd dataset and simply assembled the statement with one big formula.

Spoiler

iif(hours>0,ToString([hours])+ " Hours","")
+

iif([minutes]>0,iif([hours]>0, " "+ ToString([minutes])+ " Minutes", ToString([minutes])+ " Minutes") ,"")
+
iif([Seconds]>0,iif([hours]>0 or [minutes]>0, " "+ ToString([Seconds])+ " Seconds", ToString([Seconds])+ " Seconds") ,"")

Spoiler

[Qiu]

@Bennu 
It seems that you are crashing all the weekly challenges. And nice approach you have taken for this one. 😃

[Minanashat]

[DylanBell]

Definitely more satisfying to see the time in this format 

[RebekaMazuchova]

:)