View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Formatting Cells

I would like to change the format to show hours and minutes where the hours
are over 24. By going to the format list I see one that almost fits the bill
but not quite. [h]:00:00. Is there a way to put in my own formula which would
be [h]:00 as I don't want the seconds.