Format time cells in Excel to display AM/PM times but not the AM or PM
Posted on 2014-11-23
In Excel (2013), is it possible to format a cell so that it displays AM/PM times but not the AM or PM?
For example, in both the Time & Custom sections of Cell Formatting, I found several different options for 24 hour (ie military time) formatting:
11:30, 12:00, 12:30, 13:00, 13:30, 14:00
and several options for AM/PM formatting:
11:30 AM, 12:00 PM, 12:30 PM, 1:00 PM, 1:30 PM, 2:00 PM
However, I'm trying to find a formatting setting which matches the AM/PM example but without the AM/PM:
11:30, 12:00, 12:30, 1:00, 1:30, 2:00
In other words, I'd like to have all times >= 1:00 PM to display as 1:00, 1:30, …etc.