Formatting Category Label

Is there any way to format the category label on a chart besides through query functions. I am using SQL express and the closest format I can get is HH:mm:ss. Would like to strip it down to HH am/PM.


Found a way to do it through my SQL query.

select RIGHT(CONVERT(VARCHAR(26), logdatetime, 100), 7)