How to calculate word count into TRT

[Branden]

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?

[Nyaruko]

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

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

[ScottWorld · Accepted solution]

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]

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

[Branden]

Perfect! Thank you so much!