View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ryanp ryanp is offline
external usenet poster
 
Posts: 5
Default convert time format

Hi,

I would like to convert time format from military format to AM/PM.

Current format: 15:10:03
Wanted format: 3:10 pm

I used cell format/number/time, but it does not work.

Thanks for reading.