+ Reply to Thread
Results 1 to 3 of 3

Working out overall percentage of units available, units complete against time waitin

  1. #1
    Registered User
    Join Date
    06-23-2020
    Location
    Manchester
    MS-Off Ver
    10
    Posts
    1

    Working out overall percentage of units available, units complete against time waitin

    Hi,
    I am somewhat of a noob when it comes to excel and formulas. I will apologise if this has been asked and answered previously.
    I am looking to find out the overall percentage in the spreadsheet I need to get completed.
    So, I have number of units (30) then number of units completed (30) then time waiting(0-60 dependant on job). I can get the first part of the formula done, its just adding the time in and getting an accurate % rate back.
    I hope I have explained it right.
    Many thanks
    Attached Files Attached Files
    Last edited by Darkdeathstalka; 06-23-2020 at 04:17 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Complete Novice at excel, help needed

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Quang PT

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Working out overall percentage of units available, units complete against time waitin

    1. Please explain your logic to get the answer you are looking for if you had to do this manually.
    2. Show us what your mocked up solution would be based upon 1. above.

    I am not completely understanding your needs -- so therefore answers to 1 and 2 above will assist greatly to get your solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-06-2020, 06:57 AM
  2. Excel Programming Help - Complete Novice
    By Andy_3155 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2017, 05:26 AM
  3. Replies: 7
    Last Post: 02-14-2015, 03:56 PM
  4. Hi Guys and Gals, complete novice to Excel here to learn.
    By CrazyStu in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-12-2014, 12:08 AM
  5. A complete novice in need of a user form
    By rcwife in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-03-2013, 07:32 PM
  6. [SOLVED] Excel Novice: Data Validation Help Needed
    By cdpeckham in forum Excel General
    Replies: 4
    Last Post: 09-24-2012, 10:05 AM
  7. Complete Novice requires help
    By skeates in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-15-2009, 07:31 AM

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