JDT

No...go to the menu option Format

Then Cells...

The Number Tab

The bottom of the list is an entry called Custom

Click on this

A list with a box at the top will appear

In the box type [hh]:mm or [h]:mm

The difference is with 1:00 hour the first one will show 01:00 the second
1:00

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"JDT" wrote in message
...
On Wed, 2 Feb 2005 21:10:26 -0000, "Nick Hodge"
wrote:

Me thinks you didn't read the reply ;-)

FormatCells...Custom and enter [hh]:mm

Note the [ ]. It stops the hours incrementing to days over 24, likewise
[mm]:ss will stop minutes incrementing to hours over 60

OK, I found it. FormatCellsTime 37:30:55 also works. However, I
don't have [hh]:mm, but I do have [h]:mm:ss, which works. Am I
overlooking something, or is that an add on or something? (Office
2000)

Thanks for your help

JDT