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.
Maybe not directly, but you can do it like this (time is in A1):
If your 'AM / PM' formats differ, then change the entries in the substitutions. For example (without the periods between the am and pm):
Note that the result is a string, rather than a time value, but if you are doing this for display purposes, rather than for any further calculation, that might not be a problem for you.