Convert time to "x hours, x secs"

[christophebrock1]

Hello,

I would like to convert a time to a format like this:

"46h 25min"

So basically, I want the number to exceed the 24 hours in the hour AND HAVE "h" and "m" as values in my textfield.

I have no clue how to do this... Tried too many things already so looking for help 🙂

for example, I have this:

04:04:38

This would need to become:

"4h 4min"

with the option to exceed the 24 hours if it would be more.

Any thoughts?

Kind regards,

Christophe

[rubenmarin · Accepted solution]

Hi Christophe, can you try?:

=Interval(TimeField, 'hh') &'h '& minute(TimeField) & 'm ' // To add seconds: & Second(TimeField) & 's'

[mtucholski]

Hello,

take a look at a file sample. I used Dual() function

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/FormattingFunc...

You can find Dual() used in load script and in chart's expression. Pick whatever you want .

Please take a look at number settings in both document and chart properties.

cheers

[christophebrock1]

Thanks, this worked like a charm!