View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Enda K Enda K is offline
external usenet poster
 
Posts: 1
Default How do I convert US date with 12hr format to European date 24hr

I am using Excel. I have a mix of 24hr and 12hr AM/PM format pulling from a
database. I want to reformat all dates with time to the 24hr clock so that I
can then have 1 format to manipulate