Thread: Elapsed Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Elapsed Time

=MAX(B1-A1,0)

where B1 is the actual time, A1 is the handicap.

--
__________________________________
HTH

Bob

"KevinT" wrote in message
...
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