Hi,

I need some help calculating regular/overtime hours for a payroll spreadsheet. I am able to calculate total hours by inputting in time and out times but I am unable to figure out formulas to do anything else.

I have a column for lunch. If "y" is inputted in the column then .5 hours need to be deducted from total hours in a separate column, giving a value of total payable hours. I have columns for regular hours and over time hours. If total payable hours are over 9 then only 9 hours should be in regular hour column and remaining should automatically be inputted under over time hours. Will anyone be able to help me with a formula for total payable hours, regular hours and over time hours formulas?