Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to calculate word count into TRT

Topic Labels: Formulas
Solved
Jump to Solution
1356 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!