Results 1 to 5 of 5

Formula to calculate the percentage of work completed

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    The Nasonverse
    MS-Off Ver
    Office 2010 Professional
    Posts
    2

    Formula to calculate the percentage of work completed

    I was given a problem by a friend of mine to see if I could figure it out. I can't. The problem is this:

    A production line produces 280 cases in 1 hour. The workday lasts 12 hours. This totals to 3360 cases, at 100% of the daily quota. I need a formula that will show the percentage completed. For instance, after 6 hours, it should show 50% completed. I've uploaded my workbook, and thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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