Which version of Excel is that, Jarek?
That format isn't accepted in my Excel 2003. I suggested [h]:mm
--
David Biddulph

"Jarek Kujawa" wrote in message
...
select yr range of cells, press CTRL+1 (or Format-Cells), go to
Numbers tab, select Customized and use yr [h]:00 format


On 14 Sty, 14:49, 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.