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