+ Reply to Thread
Results 1 to 2 of 2

division between cells

  1. #1
    Registered User
    Join Date
    12-11-2009
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question division between cells

    im trying to set up a simple sort of program for my mum who is a proofreader where i have a list of documents then the number of pages in each document and the time taken in minutes to proofread that document. Is there a way of putting in a formula so that every time a document is proofread mum can enter the time and pages and in a 4th column it will calculate the rate of minutes per page? I'm guessing its a simple division but can't work out how 2 do it without working each one out manually each time. REALLY appreciate any help!! Thanks in advance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: division between cells

    She can enter the start and stop times using Ctrl+Shift+;

    Then the number of pages per minute is =1440 * #pages / (stop time - start time)
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1