Sign in to follow this  
Dan

Formula For Wpm

Recommended Posts

I was just wondering what is the formula for words per minute and how to put it in a spreadsheet??

I my spreadsheet is like this so far:

A1= # of Words    B1= X

A2= WPM            B2= X

A3= Time            B3= Formula???

So B1, and B2 is the # of words and WPM.....

If anyone could tell me what to put in B3, that would be great!

dk :)

Share this post


Link to post
Share on other sites
I was just wondering what is the formula for words per minute and how to put it in a spreadsheet??

The formula is, uh, words / minutes. How you handle the spreadsheet with depend on what software you're using and how you want to format the sheet. Here's an example I made in OpenOffice:

spreadsheet.jpg

The equation for cell B3 is in the equation bar.

Share this post


Link to post
Share on other sites

To get seconds you'd need to multiply the minutes by 60 to get seconds, then use modulus 60 to get the number of seconds.

Something like:

seconds = (time * 60) % 60

minutes = int(time / 60) providing int rounds down, otherwise you may need to do a floor(time) to eliminate the decimal

then minutes:seconds would be your output.

Hope that helps.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this