For what it may be worth, here's my Kobo reading time columns setup. I've added two custom columns that display the reading time and reading time remaining in hours/minutes instead of seconds.
The templates for the two columns are:
Code:
program:
total = $#kobo_time_spent_reading;
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')
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')