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.

[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: