I use a spreadsheet for payroll to enter time cards since I have multiple companies. I have a nice formula to calculate regular hours vs. overtime, but when I try to add vacation and holidays I get errors. I like to use a V or H instead of numbers so it calculates in a separate column. I get the #Value! error in the regular and overtime columns because of the text. I am trying to add to the current formulas in regular and overtime to convert the text to a zero value but I cant get anything to work. This is my current formula for regular time calculation:
Thank you very much for responding! It made me so happy to not see that error. The formulas works for everything except OT. Regular stops at 40 hours, but the OT doesn't calculate anything. If you put all 12's in the days you can see what I mean.
While i'm thinking of it, Holidays are included in our OT calculations. Can you think of anything that would stop the Regular hours at 32 when there is an "H", while keeping the other part of the formula in tact?? I think that's where my main issue lies, trying to get more than one scenario in the same formula.