View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] seo.getacho@gmail.com is offline
external usenet poster
 
Posts: 1
Default adding a colon to military time

On Thursday, December 6, 2007 11:23:03 PM UTC+5, Suzanne wrote:
I need to add a colon to military time. I need to change it from 1700 to
17:00. I want it to stay in military time. I don't want am or pm to show.
I can't figure out how to do this on the worksheet. Anyone know how to do
this?


bakwas; follow it; http://facebook.com/hatetharkipeople