I am trying to display times in Google Sheets without an AM/PM indicator, but with 12-hour time (not 24-hour "military-style" time). I do not need the AM/PM indicator as it is redundant in my situation.
I'm currently using a custom date and time format:
[Hour (1)]:[Minute (01)][AM/PM (p)]
...which displays 2:15 PM as "2:15p".
If I change this to:
[Hour (1)]:[Minute (01)]
...it displays 2:15 PM as "14:15". However, I do not want 24-hour time.
Is there any way to leave off the AM/PM indicator while still displaying the hours in 12-hour time format?
I'd rather not do the formatting in a formula (converting the values to text) as my times are consumed by formulas in other cells.