View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
darkbearpooh1
 
Posts: n/a
Default Military time trouble


needa macro or something to change the time format of hh:mm to 1-12then
1-12 again instead of 13:00 so it would go from 12:30 to 1:00 instead
of 13:00
any ideas? tia


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514066