
Not applicable
2017-04-26
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- qlikview_deployment
4,614 Views
1 Solution
Accepted Solutions

MVP
2017-04-26
11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 Replies

MVP
2017-04-26
11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try with Interval
=Interval([MyTime]/86400,'D hh:mm:ss')

Not applicable
2017-04-26
12:43 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Many thanks Sunny, with your message I have been able to fix it.
3,855 Views

Contributor
2019-07-16
11:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can I add string ' days' after number of days with this calculation??
3,313 Views
