Converting time

[BillyL14]

Hi

Is there a way to covert string 10:30 am to date/time data type? I have used custom format HH:mm which worked but I don't know how to factor the am/pm. So 6:45 pm is coming up as 06:45, which is obviously wrong.

Thanks

[Emil_Kos]

Hi @BillyL14,

Yes you can do this. This article should be helpful: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parse-Date-Time-Tool-can-it-specify-AM...

[JosephSerpis · Accepted solution]

Hi @BillyL14 I mocked up a workflow let me know what you think?

[atcodedog05 · Accepted solution]

Hi @BillyL14 

Try this formula

DateTimeParse([Field1],"%I:%M %p")

Hope this helps 🙂

[BillyL14]

@atcodedog05 @JosephSerpis  thanks!

[BillyL14]

@Emil_Kos thanks

[atcodedog05]

Happy to help 🙂 @BillyL14 

Cheers and happy analyzing 😀