Skip to main content

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?

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. 

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 

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. 


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

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 


Perfect! Thank you so much! 

Reply


Terms & Conditions