Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shannoypaul
Contributor

How to convert Duration in seconds to HH:MM:SS?

I have a column with data only in seconds for e.g. 5402s
This I want to split it as 01:30:02 i.e 1 Hour 30 Minutes 2 Seconds.

Thanks in advance!

Best Regards,

Shannoy

1 Solution

Accepted Solutions

Re: How to convert Duration in seconds to HH:MM:SS?

Hi,

Try like this

=interval(timestamp#(5402, 's'), 'hh:mm:ss')

Regards

ASHFAQ

3 Replies

Re: How to convert Duration in seconds to HH:MM:SS?

Hi,

Try like this

=interval(timestamp#(5402, 's'), 'hh:mm:ss')

Regards

ASHFAQ

balkumarchandel
Valued Contributor II

Re: How to convert Duration in seconds to HH:MM:SS?

=Time(5402/24/60/60,'hh:mm:ss')

Re: How to convert Duration in seconds to HH:MM:SS?

=Interval(5402/86400)

Community Browser