AM/PM Conversions Formula

jmathew94

I have data within my column pulling in with different formatting which i have fixed, however the formatting for the time is coming over incorrectly. I have attached an example in which the time appears as AM when it should be PM. I have used several formulas found within the forum, but none seem to work for my situation. Please assist.

Time Formula.PNG

Alteryx Time Change.PNG

DataNath

Hey @jmathew94, you're currently parsing it using %H:%M:%S which would be 24 hour. However, as your incoming Timestamp is 12 hour with the AM/PM, you'll need to parse it in the same way as you're formatting it i.e. %I:%M:%S %p. Like so:

Correctly parse AMPM times.yxmd