View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Netorius77 Netorius77 is offline
external usenet poster
 
Posts: 4
Default Change text (8:30 PM) to military time (20:30)

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

Is there a straightforward way to do this?