+3I 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?
Best answer by ScottWorld
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
+7Hi 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.
+35Actually, 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
+3Hi 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!
+3Actually, 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.