Rank Errors and Automatic Sorting

The attached file is a sample of what I'm trying to build.

Day 1 Revision Tab:

Rows 10, 11, 14, 36 and 40 should all be returning the same rank. This is not then case when the interval time creeps up to more than one hour. Any suggestions?

Day 1 Printout Tab:

This tab will serve as a printout for racers to be posted on a wall. I cannot figure out how to rank all the participants without involving any filters, manual sorting or coding (final user of this spreadsheet is Excel limited).

Spreadsheet must be Excel 97-2003 compatible.

try
=IF(ISERROR(J5-E5),"*",ROUND(J5-E5,10)) times always have problems unless rounded
you may have to round everything first

not sure whats supposed to be on it, but you cant use iferror if you want compatability
but maybe this