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?
Solved! Go to Solution.
Wrap each Time column reference in TEXT().
Concatenating? Screenshot?
Wrap each Time column reference in TEXT().
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
It is not.
Yeah, you’re own your own with adding suffixes to the numbers. Luckily that’s really easy to to do programmatically.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |