View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Formatting Cells

hi
you got it.
formatcellcustom tab.
in the custom box, i would use [hh]:mm

Regards
FSt1

"Sue" wrote:

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.