Datatype Convert

[sgaryali]

Hi,

I have a field of values which is given to me as integers.  The problem I have is that the data is actually time.  I need a way to convert the integers to time format.

Like

 10 should be 10:00

10.15 should be 10:15

How can we do this?

[Luke_C]

Hi @sgaryali 

The datetime functions can help:

• First convert to a string and use the datetimeparse function
• Then use datetimeformat to get your desired format

I keep this page bookmarked, it has all the formulas and syntax information:

DateTime Functions | Alteryx Help

[sgaryali]

Hi @Luke_C 

Yes this works but now I need to convert it in decimal but so in way that it gives exact value.

Like if I convert 10:15 into decimal it will be 10.15 then multiply by 24 (10.15*24) = 10.25.

I am able to do this in excel but how to do it in alteryx?

[Luke_C · Accepted solution]

@sgaryali Something like this maybe?