Creating a pages per minute record

[Kyem_Asa]

Hi all! I’m trying to create a reading log where I track my time spent reading. I would like a record to show how many pages I’ve read per minute during a particular session. What’s the best way to do this?

[Elias_Gomez_Sai]

I would have Tables for Books and Sessions, and you could have also Authors, Editorials and so on. You can add a Number field for the number of pages on Sessions table, and a Linked Record field to relate the book. You should also add a Duration field for the minutes read, and then a Formula field to calculate pages/minutes.

If you had a premium plan you could use the Time Tracker block for the sessions:

Airtable - Support

Time tracker block

The time tracker block is part of Airtable Blocks, a Pro plan feature. Blocks let you extend the functionality of your bases: you can use blocks to bring new information into Airtable, visualize an...

[Andrew_MacNeill]

Couldn’t you also do a Rollup after the fact with Average({Duration})?

So with the Duration field and # Pages, the Average formula field (in the sessions table) is {Pages}/{Minutes}

And then in the Books table, your roll-up is AVERAGE({Duration}).