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