Convert decimal time to hh:mm:ss

[rimaissa]

Hi, trying to figure out how to convert a decimal time, 1.22 to 01:13. 2.53 to 2:32 (rounded). Is there a way to do this in Alteryx?

[binuacs · Accepted solution]

@rimaissa One way of doing this by multiplying the decimal part to 60 and then add the minutes to the result

[PhilipMannering · Accepted solution]

Another way of doing this,

ToDateTime([Time]/1440)

[binuacs]

@PhilipMannering very simple and excellent solution !!!

[PhilipMannering]

@binuacs Thank you, yeah I just discovered this.

So todatetime([Value]) - where [Value] is a number - will just add days to "1899-12-30 00:00:00". So to add minutes you can just divide [Value] by the number of minutes in a day (1440) and set the output data type to "Time".

[rimaissa]

Thank you both!! LIFE SAVERS!!