Concatenated Time fields getting 24hr time

[Austin]

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?

[Steve]

Concatenating? Screenshot?

[Austin]

[Steve · Accepted solution]

Wrap each Time column reference in TEXT().

[Austin]

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

[Steve]

It is not.

help.appsheet.com

DAY()

Day of month from Date, DateTime, or Time

[Bahbus]

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