How we Parse a Time in Alteryx ?

Question

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 PM13:00 PM10:37 AM10:37 PM11:38 PM20:00 PM

binu_acs · Answer

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

Time_0909.yxmd

DataNath · Answer

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:

Parse Time.yxmd