I have a spreadsheet with some data, which are start and finish times for an event.
I have a third column where I subtract one from the other to get the elapsed time.
I now want a column of the orders from fastest to slowest.
Does this make sense? I have absolutely no idea what I should be searching for using google to find this answer. Sorry for what I assume is a trivial question.
Example
Start Finish Elapsed Order
09:00 10:10 1:10 3
09:01 10:00 0:59 1
09:02 10:05 1:03 2
How do I get that “Order” column using a formula?