View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laurenm laurenm is offline
external usenet poster
 
Posts: 12
Default Time frame conversion

Hi All,

I am using Excel 2003 and am wondering if there is a way to change the way
Excel displays time. For example, now it is based on 24 hours as opposed to
12 hours so when I put in 1:00 the cell sees it as 1:00AM. I will need to put
in 13:00 for the cell to show it as 1:00PM. If there is anyway to do this, I
would appreciate any helpful advice.

Thanks,
LaurenM