Thread: Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co
=IF(A6--"12:00",TEXT(A6-"12:00","h:mm"),TEXT(A6-"0:00","h: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
Reply With QuoteReply With Quote