Ask Your Question

Libreoffice Calc - How to get the data order?

asked 2020-02-28 12:42:40 +0100

user0365364 gravatar image

updated 2020-02-28 12:42:58 +0100

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.


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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-28 12:52:14 +0100

user0365364 gravatar image

The "RANK" function is what I should have been searching for.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-28 12:42:40 +0100

Seen: 42 times

Last updated: Feb 28