View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Formatting Cells

Which version of Excel are you using? In Excel 2003, your [h]:00:00 is not
a valid format and will not be accepted.
I think you wanted [h]:mm
--
David Biddulph

"Sue" wrote in message
...
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.