Sort recent is the last access date. Sort by date added will sort by the date the book was added or whatever Kobo Utilities sets from it's date option when updating metadata.
As for adding books to my Finished collection, I used a custom column which basically says Finished when the Kobo reading percentage is 100.
Misc. column build from other columns templates:
Finished
Code:
{:'cmp(field('#koboreadpct'),100,'','Finished','Finished')'}
Book Reading Time
Code:
program:
total = $#kobo_time_spent_reading;
hours = floor(total/3600);
minutes = floor(mod(total, 3600)/60);
seconds = mod(total, 60);
def format(v, str):
if v == 0 then return '' fi;
return v & ' ' & str & ' '
fed;
format(hours, 'hr') & format(minutes, 'min') & format(seconds, 'sec')
Remaining Reading Time
Code:
program:
total = $#kobo_rest_of_book_estimate;
hours = floor(total/3600);
minutes = round((total-hours*3600)/60);
def format(v, str):
if v == 0 then return '' fi;
return v & ' ' & str & ' '
fed;
format(hours, 'hr') & format(minutes, 'min')