rate

  1. S

    Calculate hourly rate when SOME of the records are LESS than an hour?

    My formula is Daily Rate / (Total Hours * 24) Worked great until I hit a computation with 53 minutes. Background: job pays $45, and can take up to 3 hours, but often takes less time. For the first time, the job only took 53 minutes. The formula returns an hourly rate of $0.08 instead of a...
  2. Y

    Formula to make list shorter

    Hi guys, I was wondering if somebody could help me with the following. I have three columns, if somebody dials 93xxxxxxxx numbers the rate wil be charged 0.1575, and if someone dials 9320xxxxx the rate will also be charged0.1575. In this case i want to delete the row with the prefix 9320...
  3. K

    From excel timesheet create a import file csv

    Hi, really hoping for some help please. I have a excel timesheet which details hours worked against different pay elements. For example , columns would be ... Ee no., name, no.of hrs, hourly rate, total pay. Header above theses columns would be PE Basic pay( 88). Following to the right , the...
  4. Y

    Finding a value based on an effective date with multiple criteria

    I have a sheet with pay rates. There are about 80 different pay rates that differ for age, gender and competition type. Rather than have a sheet with a rate for every day of the year for the past 12 years I'm wondering if there is a way to do this with effective dates. So when I'm looking up...
  5. T

    Excel 2010 Charts Question

    Hi, I a trying to create a 2-d column chart that has a secondary axis on the right hand side to show percentages using the data below Sales Success Rate Pre Launch 20000 15% Post Launch 30000 20% I want to see...
  6. reneev

    Pull info from First Column with Data

    I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...
  7. L

    multiple total time by number

    Hi I want to add time then multiple the result by rate which is 10. So I have my time formatted as hh:mm then I used =Sum(B1:B4) to find the total which is 21:00 Now I want to multiple 21:00 by 10 to find how much to pay I got 18:00, clearly that is wrong. So I convert the total pay cell to...
  8. B

    Calculate interest rate

    $1,000 grows to $1,000,000 in 200 periods at what interest rate? thanks :confused:
  9. T

    Transpose rows based on specific text

    Hi all I'm trying to speed up the transpose process. When I copy an order form from online it pastes it all into Col A but I need to make it easier to read as I already have the next stages in place. The problem is the site changes from time to time and I have to redo the sheet. The common...
  10. L

    Graph Question with 2 X-axis

    Hi I have 2 data columns A - Heart Rate (example 165) B - Perceived effort (8.5) I would like to chart both of these by having 2 X-axis... Heart rate on the left and Effort on the right... I can't see to set these up so that the lines are somewhat normalized and plotted to together... Can...
  11. F

    Using range.find with an offset

    <tbody> Name (Column AD) Category (AE) Total Hrs (AF) Pay Rate (AG) Wage (AH) John Doe 1 TT Field 12.5 <tbody> $104.55/hr </tbody> <tbody> $1,306.88 </tbody> John Doe 2 TT Field 4 <tbody> $104.55/hr </tbody> <tbody> $418.20 </tbody> John Doe 3 Field 15 <tbody> $34.85/hr...
  12. J

    Determination of the absence rate

    Hello everybody, I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months. So far, I've just added the factor to the pivot calendar, whether it's a workday. The table with the presence or absence of the employees is structured as...
  13. S

    Calculate Growth Value When Drawing Down Funds

    Hello, I want to create a spreadsheet where I start with a fixed value, say £100,000 which will grow at a rate of (say) 4%pa for 10 years when I will start drawing down capital at 10%pa. This part of the calculation is easy but what I then want to do is to apply the original 4% growth to the...
  14. J

    User Form or Formula?

    I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name. Would I use a user form or formula...
  15. G

    Dependent drop menu with formula

    I'm trying to create an excel sheet with 4 columns. Column A will have a dropdown list of choices. Column B will have a dropdown list of either yes or no. Column C will be the weight you need to enter. Column D will show the value after it auto calculate. On a separate tab, there would be...
  16. A

    Lookup formulas in specific columns

    Hi Everyone I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the specific profile in Sheets(1). In Sheets(1), there are headings for 'Profile', 'Cost' and 'Rate'...
  17. H

    Excel function to compute Nominal Int Rate where effective Rate is negative

    I would like to know if there is a function in excel to compute the nominal interest rate if the effective rate is negative If the effective rate is positive the formula =Nominal works perfectly I can however compute this using a mathematical/accounting formula <b></b><table...
  18. B

    Checkbox Macro - Multiple Checkbox

    Hello, I have a workbook with 2 sheets. Sheet 1 contains 3 rate plans all with their own checkbox (form) 1. Basic 2. Advantage 3. Gold I have a second sheet that all the inclusions of the rate plans. I have added on the top of the sheet the rate plans and a check box next to the inclusion...
  19. B

    Form Control Checkbox - Multiple Checkboxes

    Hello, I have a document that has a couple of sheets. Sheet 1 has 3 rate plans 1. Basic 2. Standard 3. Platinum Each rate plan has the inclusions documented on another sheet in the same workbook. What I would like to know is it possible for a rate plan to be selected and the inclusions on...
  20. L

    Assign "grading" based on multilpe criteria

    I have a table of data with multiple fields that I need to include to assign a classification, or "grade" to. For example, in my data, I have: department floor set date region average rate of sale I need to assign an "A" to those items who are in the top 30% of rate of sale for each...

Some videos you may like

This Week's Hot Topics

Top