Convert decimal days in hh:mm:ss

[Anonymous]

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.

[sunny_talwar]

May be this:

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

[Anonymous]

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

[vishsaggi]

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')