MobileRead Forums - View Single Post - Custom Column

kcar181 · 07-29-2020, 08:08 PM

Ok so if id like just minutes im guessing this would do the trick

Code:

program:
format_number(multiply(divide(divide(raw_field('#chars'),310),60),60), '{0:5,.2f}')

And the first code was closer to hours so 1.86 would translate to 2 hours 26 minutes?

EDIT: Ok learning something new. So I think 1.86 would be a decimal hour so 1 hour and 86/100 of an hour.

07-29-2020, 08:08 PM	#11
kcar181 Member Posts: 15 Karma: 10 Join Date: Jul 2020 Device: none	Ok so if id like just minutes im guessing this would do the trick Code: program: format_number(multiply(divide(divide(raw_field('#chars'),310),60),60), '{0:5,.2f}') And the first code was closer to hours so 1.86 would translate to 2 hours 26 minutes? EDIT: Ok learning something new. So I think 1.86 would be a decimal hour so 1 hour and 86/100 of an hour. Last edited by kcar181; 07-29-2020 at 08:18 PM.