Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Time per 100 words

Topic Labels: Formulas
1287 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

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.

3 Replies 3

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?

Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

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)

Tobin_Perry
6 - Interface Innovator
6 - Interface Innovator

Actually I decided to go a different route and did Words Per Hour. That may be more helpful anyway. It worked fine.