Concatenated Time fields getting 24hr time

I am concatenating 2 time fields and I am getting 24 hr time. They are 24hr time CHAR fields in our database so I’m assuming that’s why. How can I force the time to be 12hr when concatenating or do I have to convert them to their 12 hr variant text values before concatenating?

Concatenating? Screenshot?

Wrap each Time column reference in TEXT().

1 Like

I don’t see a way to get “August 3rd” from the TEXT(), I see how to get August and 3 or 03 but the suffixed date doesn’t seem present. Please tell me it’s in there :disappointed_relieved:

It is not.

Yeah, you’re own your own with adding suffixes to the numbers. Luckily that’s really easy to to do programmatically.