View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cottage6 cottage6 is offline
external usenet poster
 
Posts: 108
Default Military Time & Colon

Hi All,
A user here would like to be able to key military hours, say 1500, and have
the cell format to 15:00. She doesn't want to type the colon. I have the
cell formatted as Time 13:30:55 which works great to show her military time.
Is there a way to do this? TIA and have a good day!