How we Parse a Time in Alteryx ?

[rohit782192]

I have one Data set which contains only time from the server as below.

I have idea on the Datetime as Alteryx take ISO format. But i am little confused only on the Time format as seen for the First Time.

How we Parse this type of Data.

12:00 PM

13:00 PM

10:37 AM

10:37 PM

11:38 PM

20:00 PM

[DataNath]

Hey @rohit782192, this can be done with the DateTime tool but I have a preference of using the Formula tool, which would look something like this:

DateTimeParse([Time],'%H:%M')

Is your incoming data automated? Just find it a little strange that it uses military time and still keeps AM/PM.

Edit: If you did want to use the DateTime tool you could just do so like this:

[binuacs]

@rohit782192 Another way of doing this. I put the correct format of the time