Time Format

[Hiteshp]

Hello All,

I need to change m/d/yyyy  hh:mm:ss AM/PM to 24 hours time format like hh:mm:ss. The incoming data is in V_WString format

Time	New Time
7/1/2024 12:01:00 PM	12:01:00
7/1/2024 01:36:54 PM	13:36:54
7/1/2024 02:44:23 PM	14:44:23
7/1/2024 03:18:00 PM	15:18:00
7/1/2024 04:00:59 PM	16:00:59

[caltang]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Convert-String-to-Time/td-p/50...

Hope this helps

[caltang]

You could also consider text to columns and using space as a delimiter. Then use the 2nd column generated and use a multi field formula tool to convert it to time format.

[Qiu · Accepted solution]

@Hiteshp 
A quick sample as below.
We can use DateTimeParse function and choose the Field Type to be Time

[Hiteshp]

Thank you for your help