View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
shadestreet shadestreet is offline
external usenet poster
 
Posts: 1
Default Format cell as military time


If your goal is to be lazy, why not just format the cells to military
time and then type in "1 pm", "6 am", "11 pm", etc. The output would
be: 13:00, 6:00, 23:00.

Personally typing 1 pm is faster than typing 1300 since your fingers
toggle between numbers and letters.

If you want to have 6:00 appear at 06:00 then instead of formatting to
time, go to custom and enter hh:mm into the box.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=562200