
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 28, 2020 07:44 AM
I’m a professional writer, and I have a table where I put all the projects I turn in. On the table, I list how long a project took me (duration) and and how many words it was (#) (along with other factors).
What’s the easiest way to create a formula that will give me the time it takes per 100 words? I keep messing up each time I try.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 28, 2020 08:04 AM
The data required to meet this computation is pretty simple (as you already know) -
- Total words written
- Total time spent
You need a duration field (which I assume you already have) and a field with the total words for each project. The last field is simply duration / (# words / 100), right?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 28, 2020 08:24 AM
Yeah, but I keep getting 0:00 when I’m done. The final formula is: {Time to Complete}/{Per 100 Words}
I created a field called Per 100 Words that is (Word Count/100)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 28, 2020 08:31 AM
Actually I decided to go a different route and did Words Per Hour. That may be more helpful anyway. It worked fine.
