Questions & Answers for: hours formula excel

formula: wages*40 if hours worked>40,-40, and here is where i need help. I want excel to calulate the difference and add the two sums together to get wages earned. I try to use the IF argument and the

Trying to figure the formula below based on 9 hour work weeks and 24 hr weekends The formula is off by 11 minutes? =(DATEDIF(A12,B12,"d")*9)+((B12-INT(B12))*24-(A12-INT(A12))*24) Please be more clear ...

hours, this formula gives me their regular rate of pay, which I do not require. Please help me. Hello, The formula should go like this: =IF(C11>40,(C11-40)*D11,0) This one will give you the result of

formula that will calculate how many hours have accumulated from create date to due date. Thanks. Hello ycool11, If your asking what i think you are the formula would be =(a2-a1)*24 That assumes a2 is

...hours. I want an average of all the three months. Can someone help me with the formula for this average. Here the average formula is not giving the correct value. Month 1 Month 2 Month 3 Average ...

...hours... I need a formula that will tell me how many times in sheet 1 the value "Green" has been used in column G, but ONLY IF the value "CT" is used in column F on sheet 2. Thanks for any help... ...

...formula but the cells that contain the hours for each call. Since they contain the text ?hrs? (for example ?2.25hrs?) this turns the whole cell to text, not numeric, which will always add up to zero ...

...formula I have created a daily hours spreadsheet for payroll. I have made 7 columns for each day so that when the daily hours are imput the total will calculate in a different column. What I need is ...

...hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools ...

formula = salary rate X hours worked) 5th column - tax deduction 6th column - other deductions 7th column - total deductions (formula = tax deduction + other deduction) 8th column - net pay (formula =