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.
|