Format/Cell/Custom hh:mm

But 8:30 PM will display as 20:30. If you want 08:30 for both AM and PM,
try this in an adjacent column (where A2 contains your time)

=A2-(HOUR(A2)12)*0.5

and format this column hh:mm

"Mic" wrote:

Is there a way to:

Take a column that is formated to hh:mm AM/PM to remove the am or pm in the
same column (Think that it would have to be text)

Or

Start with Text that 8:30 and make it 08:30 without the AM/PM

Mic