|  07-30-2020, 11:02 AM | #16 | |
| Member            Posts: 20 Karma: 34258 Join Date: Jul 2020 Device: Kobo Libra H2O | Quote: 
 | |
|   |   | 
|  07-30-2020, 01:26 PM | #17 | 
| Guru            Posts: 608 Karma: 5007204 Join Date: Sep 2014 Location: Calif Device: Fire hdx 8.9, Tab S2, Tab S5e, Aura ONE | 
			
			One need to add time for high-lighting, annotations, looking up in the dictionary to estimate 'how long to read'.  Not needed for people not doing highlighting or annotations or dictionary lookup except for inadvertent highlighting via a touch.
		 | 
|   |   | 
|  07-30-2020, 01:52 PM | #18 | |
| Grand Sorcerer            Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2 | Quote: 
 Code: program:
	fractional_hours = 3.6982;
	re_group(
		fractional_hours,
		'(.*)(\..*)',
		'{$}:', 
		"program: format_number(multiply($, 60), '02.0f')"
	)Last edited by chaley; 07-30-2020 at 01:54 PM. | |
|   |   | 
|  07-31-2020, 07:01 AM | #19 | |
| Member  Posts: 15 Karma: 10 Join Date: Jul 2020 Device: none |   Quote: 
   | |
|   |   | 
|  07-31-2020, 08:16 AM | #20 | 
| Grand Sorcerer            Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2 | |
|   |   | 
|  08-07-2020, 12:04 PM | #21 | 
| Junior Member  Posts: 1 Karma: 10 Join Date: Aug 2020 Device: Kindle | 
			
			Hi guys, first post here. Sorry for my english and for my italian version of calibre  Anyway, I'll try to figure out add reading time column as show in this thread, but it doesn't work for me: I'm using a raw_field that isn't the number of words of the book but just the number of the pages (is what I have at the moment), but the results is always 0:00. What I miss?  Thanks my Calibre version: 4.16 | 
|   |   | 
|  08-07-2020, 11:38 PM | #22 | |
| Grand Sorcerer            Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos | Quote: 
 | |
|   |   | 
|  08-09-2020, 09:19 PM | #23 | 
| Guru            Posts: 918 Karma: 810834 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite | 
			
			I have configured my reading time with this template: program: # This program calculate a reading time per hour for an ebook # Adjustments: # w_min -> minimum words per minute # w_max -> maximum words per minute w_min = 250; w_max = 300; # readingtime per hour = 60 p_time = 60; # Needs a custom column for word count (#words) # change it to your field name words = raw_field ('# words'); time1 = format_number (divide (words, multiply (w_max, p_time)), '{0: .2f}'); time2 = format_number (divide (words, multiply (w_min, p_time)), '{0: .2f}'); # Unfortunately Caliber doesn't provide a simple way to convert a float # into a time string -> I used a regex # The minutes can be set to use 2 numbers using python number formatting, # otherwise times are displayed as 4: 4h instead of 4: 04h. rt1_hour = re (time1, '\. \ d *', ''); rt1_minute = format_number (multiply (subtract (time1, rt1_hour), 60), '{0: 02.0f}'); rt2_hour = re (time2, '\. \ d *', ''); rt2_minute = format_number (multiply (subtract (time2, rt2_hour), 60), '{0: 02.0f}'); readingtime = strcat (rt1_hour, ':', rt1_minute, 'h -', rt2_hour, ':', rt2_minute, 'h'); https://www.mobileread.com/forums/sh....php?p=3534411 | 
|   |   | 
|  | 
| 
 | 
|  Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| Browser Viewer: Long-text Custom Column | nqk | Server | 8 | 08-05-2018 08:25 AM | 
| Custom column long text toolbar | MerlinMama | Calibre | 2 | 03-01-2017 01:14 PM | 
| Creating Custom Column for Read and Date Read | library addict | Calibre Companion | 11 | 03-22-2014 05:33 AM | 
| Custom yes/no column built from long text column | Philantrop | Library Management | 7 | 03-23-2013 07:44 PM | 
| No search/replace on custom long text column? | CWatkinsNash | Library Management | 2 | 06-20-2011 05:57 PM |