Help

How to calculate word count into TRT

Topic Labels: Formulas
Solved
Jump to Solution
349 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Branden
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to take the word count of a book (ex: 100,000 words)

divide that by 9,300 (which is how many words an average narrator can read per hour)

to come out with the actual time in HH:MM format. 

This is the formula I have currently and how it turns out.

 Screenshot 2024-05-23 at 12.43.29 PM.png.   

Screenshot 2024-05-23 at 12.44.05 PM.png

What formula would I use to divide the word count by 9300 to come out with a HH:MM?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Actually, you just need to do this formula:

{Word Count} / 9300 / 60 / 60

And then set the formatting on the field to “duration”.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

See Solution in Thread

4 Replies 4
Nyaruko
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Branden,

In place of your formula:

 

{Word Count} / 9300

 

 Use the following formula:

 

IF({Word Count}, INT({Word Count} / 9300) & ":" & IF(ROUND((({Word Count} / 9300) - INT({Word Count} / 9300)) * 60) < 10, "0" & ROUND((({Word Count} / 9300) - INT({Word Count} / 9300)) * 60), ROUND((({Word Count} / 9300) - INT({Word Count} / 9300)) * 60)), "0:00")

 

wordcount+runtime.png

For transparency's sake, I got this solution from ChatGPT and this was its second attempt. 

ScottWorld
18 - Pluto
18 - Pluto

Actually, you just need to do this formula:

{Word Count} / 9300 / 60 / 60

And then set the formatting on the field to “duration”.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Branden
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked but wow, I would not have figured all that out on my own! 

Perfect! Thank you so much!