cancel
Showing results for 
Search instead for 
Did you mean: 

Decimal Time to hh:mm:ss Format

SOLVED
Highlighted
mstadler
Atom

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
Alteryx Certified Partner

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
Atom

Thank you.  This worked perfectly.

 

Thanks,

 

Matt