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


Is this just a formatting issue?

If you show 13:00 as 01:00 how can you tell 01:00 from 13:00? Or do you
want to show AM and PM, if so just format cell to show hh:mm AM/PM


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