View Single Post
  #1   Report Post  
JRV
 
Posts: n/a
Default macro to change text to time

I have a large spreadsheet of information extracted as text. The time
columns are entered as military time, but do not have the colons, 735, 1257.
Would anyone know a macro that can be run down the columns to change the
number to time, 07:35 AM, 12:57 PM? Thanks,