View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sedoc sedoc is offline
external usenet poster
 
Posts: 3
Default How do I Change text (0130PM) into military time equivalent?

I'm trying to change times that are reported in text format (ie 0830PM
instead of 8:30PM) into military time equivalents.

Is there a straightforward way to do this?