Output seconds to hh Hour mm Min format

I want to convert seconds to “hh Hour mm Min” format. I have tried to set the unit to clock(s), its output is 12h:24m:10s:33ms which is close to my requirement. But I want to make it more friendly just show hour and minute and without ‘:’, say “12h 24m”. I tried value mapping but it doesn’t wokr. How shall do that?

Hi @rore123

Does this help?

The user prefers xx hour xx min xx sec to xx:xx:xx format. I tried to use value mapping to replace the ‘:’, but it doesn’t work. I also tried to define custom duration format, it also doesn’t work.

Yeah, I realized that after I posted my reply. If I can come up with a solution, I will post here

What is your datasource?