Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

effinty2112
Honored Contributor

Re: How to convert seconds in to DD:HH:MM:SS format

Hi Satya,

Here's another way:

= Replace(

Replace(

Replace(

Replace(

Interval(20400062/24/60/60,'dd U hh V mm X ss Z')

,'U', 'Days'),

'V', 'Hr'),

'X','Min'),

'Z', 's')

returns:

236 Days 02 Hr 41 Min 02 s

Regards

Andrew

Highlighted
satyapaleti
Contributor II

Re: How to convert  seconds in to DD:HH:MM:SS format

Thank you Andrew

wim_embrechts
New Contributor III

Re: How to convert seconds in to DD:HH:MM:SS format

Simple but effective!!