Decimal Time to hh:mm:ss Format

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

Date Time

Accepted answers

CharlieS

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.

Decimal Time Conversion.yxmd

All comments

CharlieS

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.

Decimal Time Conversion.yxmd

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..

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703