Time between library book use/top 10 books

[richh]

Hi all,

I'm trying to find a dynamic way to get the top 10 books used in a library based on the length of time they've been checked out. The entries are logged with a date/time stamp via a command button on a form. The people have the opportunity to check in and out three books at a time. I'm not too sure where to start on this one. I'm thinking it's gotta be something along the lines of =IF(AND(OR(AA:AA="Bookname", AB:AB="Bookname", AC:AC="Bookname"), OR(X:X="Bookname", Y:Y="Bookname", z:z="Bookname"), somethingsomething, somethingsomething). I may be totally off, however. I also think I may just make the date column contain only the date, not "Now" in the VBA code and only calculate dates between and not full time. I don't know if that would be easier or not...

The spreadsheet is as follows:

Date Checked In Book 1 Checked Out Book 1
9/3/2016 12:47 Crab Apples
9/3/2016 12:33 Book 1 Book 2
9/5/2016 12:33
9/7/2016 12:34
9/7/2016 12:35
9/7/2016 12:35 Book 3 Book 4
9/8/2016 12:36 Book 7
9/30/2016 12:36 Legal Book
9/30/2016 12:36
9/30/2016 12:37 Book111 book 3
10/3/2016 12:37 book 333 book 334
10/3/2016 12:38
10/3/2016 12:39
10/3/2016 12:41 Book 2
10/4/2016 12:45 book 334
10/13/2016 12:45 Nancy Drew
10/31/2016 12:46 Nancy Drew
11/3/2016 12:47
11/3/2016 12:47 Crab Apples
11/3/2016 12:48
11/3/2016 12:55 book 4
11/3/2016 12:56 book 7
11/3/2016 12:57 Legal Book
11/3/2016 12:57 book 3