Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert decimal days in hh:mm:ss

It's possible make a convert in days to interval in a decimal value?

Ex.:

0,05152 Days

It's 4451,328 Seconds. But how i can convert this to hh:mm:ss format?

Best Regards.

4 Replies
sunny_talwar

May be this:

=Interval(Interval#('4451.328', 'ss.fff'), 'h:mm:ss')

Anonymous
Not applicable
Author

This isn't work, because my decimal is 27,83333 for example...

vishsaggi
Champion III
Champion III

Use sunny's expression replacing dots with commas and try? like

=Interval(Interval#('27,83333', 'ss,fff'), 'h:mm:ss')

sunny_talwar

vishsaggi‌ is right, just tried to test this with a comma instead for decimal

=Interval(Interval#('4451,328', 'ss,fff'), 'h:mm:ss')

Capture.PNG