Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Convert seconds to days hours minutes and seconds

Good morning,

I would like to convert seconds to DD hh:mm:ss. The method I'm using is the next:

=time([MyTime]/86400,'hh:mm:ss')

That method only shows hh:mm:ss. If I try with adding DD to the method it always appears to me that there are 30 days.

=time([MyTime]/86400,'DD hh:mm:ss')


Someone can help me to get the correct days of my time in seconds.


Thank you.

1 Solution

Accepted Solutions

Re: Convert seconds to days hours minutes and seconds

May be try with Interval

=Interval([MyTime]/86400,'D hh:mm:ss')

View solution in original post

3 Replies

Re: Convert seconds to days hours minutes and seconds

May be try with Interval

=Interval([MyTime]/86400,'D hh:mm:ss')

View solution in original post

Not applicable

Re: Convert seconds to days hours minutes and seconds

Many thanks Sunny, with your message I have been able to fix it.

balajikannan2013
New Contributor

Re: Convert seconds to days hours minutes and seconds

How can I add string ' days' after number of days with this calculation??