Thanks heaps guys,

The 1904 method worked well. I've no idea why, but hey, it works.

The only thing that concerns me is that I will have to change that option in
every computer I use when I open the file.
More important though is that'll I'll have to change it back when I finish
working on it.

Kevin

"Roger Govier" wrote:

Hi Kevin

you could use ToolsOptionsCalculationUse 1904 date system
for this workbook.
That will allow negative times.

Be aware that any date calculations will be out by 1432 days on this system,
but I am assuming that dates are not of any interest in this case.

--
Regards
Roger Govier

"KevinT" wrote in message
...
Thanks Stefi,

It works fine, but is there any way I can display the hours as well?

Kevin

"Stefi" wrote:

Try to format the result cell like [m]

Regards,
Stefi

€žKevinT€� ezt Ã*rta:

Hi,

I have a worksheet in Excel 2000 that I am using for a road race.
I have the names etc of about 100 runners.
Each runner has a handicap time.
I wish to subtract the handicap time from the actual time and rank the
result in order, from lowest to highest.
I'm using the [h]:mm format for the cells.
The problem is that if a runner beats their handicap time the result
displays as #####.
Is there anyway around this?

TIA,
Kevin