Thread: Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mic Mic is offline
external usenet poster
  
Posts: 17
Default Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co
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