View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How to I convert standard time to Military or 24 hour format?

Format Cell... Number Time and pick 13:30:55
--
Gary's Student


"Nacho" wrote:

I have data with time in standard fromat i.e. 3:00PM but I need it to be in
24 hour format i.e. 15:00. How can I do this?