Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Oroville, California, Uruguay
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help in understanding Percentafe (1977)

    I would like to understand the way percentages work in Excel formula's. Example, $100.00 represents 8 hours pay. What would be 42 minutes (what percent of 8 hours is 42 minutes) and the resulting amount (What dollar amount does 42 minutes represent)? If cell A1 were to be the amount of pay ($100.00) and cell A2 would be the amount of time needed to calculate (42 minutes) then cell A3 would be ?? dollars.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help in understanding Percentafe (1977)

    Try

    =A2/480*A1

    The 480 is 60 minutes times 8hrs (There are 480 minutes in 8 hrs) 42/480 gives you the percent. Multiply this times the $100 = $8.75

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help in understanding Percentafe (1977)

    Another way of doing it is to enter the times as times.

    Enter 0:42 in cell A2 and 8:00 in (say) cell A5.
    The formula for the percentage would be simply =A2/A5. The result will be 0.0875, meaning 8.75%. If you want to see it as a percentage, select Format | Cells..., and select Percentage, with 2 decimals.
    You can calculate the amount of dollars directly: =A1*A2/A5, or via the percentage as intermediary result: say that you enter the formula with the percentage =A2/A5 in cell A6; the formula for the amount becomes =A1*A6.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Oroville, California, Uruguay
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help in understanding Percentafe (1977)

    Thanks Hans. I will utilize the info.

    Larry

Posting Permissions

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