+ Reply to Thread
Results 1 to 9 of 9

Excel help for calulating hours required

  1. #1
    Registered User
    Join Date
    02-28-2021
    Location
    SG
    MS-Off Ver
    365
    Posts
    4

    Excel help for calulating hours required

    Dear all,

    would need your kind inputs in this, I am currently doing a model for my school assignment,

    Capture.JPG,

    by multiplying this, which when summed is a total of 50000, with this values,
    Capture.JPG,

    the following values will appear
    Capture.JPG,

    and the sum of the values in the table is 203360, however, when I do a separate calculation by just multiplying the 50000 with the sum of the second table, which is 50, the values will not the same as the sum of the values when multiplied individually in the table and summing them out, not sure what is the error.
    Attached Files Attached Files
    Last edited by davesexcel; 02-28-2021 at 06:54 AM.

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Excel help for calulating hours required

    There is no error. You just don't understand mathematics. The sum of one set times the sum of the other is almost never going to be the same as the sum of individual calculations.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Excel help for calulating hours required

    Where do the numbers come from this table?

    2021-02-28_5-08-13.jpg

  4. #4
    Registered User
    Join Date
    02-28-2021
    Location
    SG
    MS-Off Ver
    365
    Posts
    4

    Re: Excel help for calulating hours required

    so say if i want a list that shows 10 values of a22 when different a3 is inputed, is there a way for me to do it with a model?

  5. #5
    Registered User
    Join Date
    02-28-2021
    Location
    SG
    MS-Off Ver
    365
    Posts
    4

    Re: Excel help for calulating hours required

    This table is the hours required to serve each person given certain conditions and the other table is to total population, so what I am trying to do is to compute the time required to serve each person within that population so as to figure out the total manpower needed

  6. #6
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Excel help for calulating hours required

    Is this now solved, as per your query in MrExcel?

  7. #7
    Registered User
    Join Date
    02-28-2021
    Location
    SG
    MS-Off Ver
    365
    Posts
    4
    Quote Originally Posted by GlennUK View Post
    Is this now solved, as per your query in MrExcel?
    Yup how do i marked as resolved?

  8. #8
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Excel help for calulating hours required

    I think you edit the thread title and add SOLVED to the text. (I've only ever answered questions, never asked them, so am guessing a little here)

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,812

    Re: Excel help for calulating hours required

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. Here is the link: https://www.mrexcel.com/board/thread...model.1163252/ You must do this yourself next time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Hours required to get to 100%
    By Kylz87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-06-2016, 10:26 PM
  2. Working out hours required
    By jimd1768 in forum Excel General
    Replies: 2
    Last Post: 09-14-2015, 09:50 AM
  3. [SOLVED] Creating calendar formula and calulating employee hours and billable hours
    By ktps in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-05-2015, 08:13 PM
  4. Algorithm matching clocked hours to required hours
    By lcg662 in forum Excel General
    Replies: 2
    Last Post: 12-23-2008, 03:19 PM
  5. calulating hours worked between two dates
    By jdavis726 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2008, 09:31 PM
  6. How do I get difference between hours worked vs. required number
    By ChicagoMerchant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2007, 04:18 PM

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