Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

May be try with Interval

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

View solution in original post

3 Replies
sunny_talwar

May be try with Interval

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

Not applicable
Author

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

balajikannan2013
Contributor
Contributor

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