Convert Excel decimal time to time in Alteryx

[AlexL]

Hello,

Inquiring if there is a tool or way to convert a decimal field in an excel report to time in Alteryx.

The select tool does not recognizing the decimal field as time when I change the format.

I.e. 

0.486643518518518 = 11:40:46 AM (hh:mm:ss)

0.5 = 12:00:00 PM (hh:mm:ss)

Please see additional examples in attached document.

[jdunkerley79 · Accepted solution]

The easiest way I can think of is to use a formula tool:

DateTimeAdd(DateTimeToday(), [Decimal] * 86400, "seconds")

A quick sample is attached

[AlexL]

Thanks! Works perfect!