Thanks for clarifying your situation. I can now reproduce the problem with the `RANK()`

function here using v4.1.0.4 under Crunchbang 11. Initially, I used whole numbers converted to times in the manner you described, but this did not reveal any problem with the function. Here is a screenshot of this method:

The *split* column is column D minus B. The formula in F2 is `=RANK(E2;E$2:E$4;1)`

and this is copied to F3 and F4.

It appears that identical values are given the same rank, thus equal first placings are both denoted with "1", and then the ranking skips to 3. If there are then equal third placings both will be denoted with a "3", and then the ranking skips to 5, and so on. The LO help entry for this function does not mention how equal values are handled, however the AOO help page for the same function does indicate that there are "issues."

The suggested AOO workaround (append `+COUNTIF(E$2:E2;E2)-1`

in my example) does produce unique values based on order of appearance. For example, if I copy the three rows shown in my example, so there are equal firsts, equal seconds, and equal thirds, (and expand the range from `E2:E4`

to `E2:E7`

) the results display as 1,3,5,1,3,5. If I then add the workaround to the formula (e.g., `=RANK(E2;E$2:E$4;1)+COUNTIF(E$2:E2;E2)-1`

for the first entry) then the results display as 1,3,5,2,4,6, which would seem better.

**UPDATE:** Using time values from your example file (refer comments below), in particular rows 26,32,33,38 and columns Z,AE,AG,AH, I can now reproduce the issue. In a new Calc file I manually keyed in the start (25k mark) and stop (30k mark) times, and used a simple subtraction of the start time from the stop time to obtain the elapsed time (5k split). A basic ranking of these elapsed times does not appear to give correct results as shown in this screenshot:

The ranks IMO should show 1,1,4,3, yet for some reason the first two entries are determined to be different. We need to raise a bug and provide a simple example file like the one I have prepared. I will confirm ... (more)

Please clarify what "a calculated time (e.g. 15k time minus 10k time)" means. Does "15k" refer to a specific time or a distance run? If you could provide an example of the time displayed (and underlying number) that results from this calculation that would be helpful e.g., "18:15:00" displayed = 0.7604166667. Also please indicate your operating system and LO version.

The results of the race give the time for each runner at 5 kilometres, 10 kilometres, etc. I therefore, for example, subtract the 10k time from the 15k to get the time taken for that 5k split. The elapsed time column is formatted H:MM:SS and the split time column as MM:SS. I then wish to use the RANK() function to compare runners for each 5k split. I'm on 4.05 with Windows 7 and also on Ubuntu 10.4.

Later] I may have a clue: initially I laboriously typed times in as e.g. "1:24:18" and ranking worked correctly. I then added a column J allowing me to enter just 12418 and used the function IF(J2>0,TIME(TRUNC(J2/10000),MOD(TRUNC(J2/100),100),MOD(J2,100)),"") to get the time for column K. Ranking now gives different ranks to equal times.