Thread: Hours and Minutes Data format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave08 Dave08 is offline
external usenet poster
  
Posts: 22
Default Hours and Minutes Data format
I am trying to format a cell so it displays Hours and minutes. I am entering
1:00 and desplaying 1/01/1900 12:00:00 AM. The formating on the cell is
HH:MM.

Reply With QuoteReply With Quote