# How to calculate word count into TRT

Topic Labels: Formulas
Solved
349 4
cancel
Showing results for
Did you mean:
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.

.

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

1 Solution

Accepted Solutions
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

4 Replies 4
5 - Automation Enthusiast

Hi Branden,

``{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")``

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

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

5 - Automation Enthusiast

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

5 - Automation Enthusiast

Perfect! Thank you so much!