topic Convert HH:MM:SS into seconds in QlikView

Convert HH:MM:SS into seconds

soha1902 — Fri, 06 Feb 2015 05:57:22 GMT

Hi All,

I have one field named "Duration" which contains the time values in HH:MM:SS format (like 00:12:36). I want to convet these values in Seconds. Please suggest me.

Thanks.

Re: Convert HH:MM:SS into seconds

arulsettu — Fri, 06 Feb 2015 06:06:19 GMT

try this

=Interval(Time#('00:12:36','hh:mm:ss'),'ss')

Re: Convert HH:MM:SS into seconds

thimma_paul — Fri, 06 Feb 2015 06:17:37 GMT

For Seconds =Interval(Time#('00:12:36','hh:mm:ss'),'ss')

Re: Convert HH:MM:SS into seconds

jonathandienst — Fri, 06 Feb 2015 06:30:31 GMT

Do you want to format it to display seconds (assuming Duration is a valid time value?

=Interval(Duration, 'ss')

Or assuming it is a string?

=Interval(Time#(Duration), 'HH:MM:SS'), 'ss')

Or do you want to convert it to seconds (assuming it is a valid time value)

=Duration * 86400

Or convert it (assuming it is a string)

=Time#(Duration, 'HH:MM:SS') * 86400

HTH

Jonathan