Convert time from 24hrs format to AM/PM

[Belletmns]

Hi Team,

I need your help, I would like to convert my data from 24hrs format to AM/PM format.

Here's how Alteryx read my data:

Here is my desired output:

Attaching my sample input file.

Thank you in advance!

[Jonny · Accepted solution]

Hi @Belletmns,

you could to use the DateTimeFormat settings for time. more here: Date Time Functions (alteryx.com)

DateTimeFormat([Time],"%I:%M %p")

see if this is what you are looking for?

Cheers!

BR/Jonny

[Belletmns]

Thank you @Jonny,

Cheers!