View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jessica C. Jara
 
Posts: n/a
Default How to I convert standard time to Military or 24 hour format?

Hi Nacho, just get on the cell, left click your mouse and in the display list
click format cells, once there click on the number page and in there click on
time. You will be able to find it there.

Hope this helps you,

Jessica

"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?