Decimal Time to hh:mm:ss Format

[mstadler]

I'm looking for a solution to show the decimal time of 0.001837 as 00:02:39.  I have searched around but I haven't found anything that accomplishes the task.  The decimal time type is Double.  Any help would be appreciated.

Thanks,

Matt

[CharlieS · Accepted solution]

I have attached a solution. I converted the decimal portion of the day to seconds by multiplying the given decimal time by 86400 (the seconds in a day). It's just formatting from there. 

[mstadler]

Thank you.  This worked perfectly.

Thanks,

Matt

[adrilarotta]

It also worked for me, thank you very much 😀

[Zion777]

thanks Charlie,  Your solutions was useful for me today, You made my day..