Hi I am a business owner and do my own invoicing /payroll I have a spread
sheet setup in excell for this.Currently my employees have there own column
where each day I insert there total hours worked so for example if you were
to sum up column l45:l51 this is the total hours the individual works in a
seven day period. I am trying to create underneath the sum at cell l52 and
l53 a formula that will seperate the regular hours l52 and overtime hours
l53. Overtime is based on hours worked over 40 in a week or if you start mid
week and total is 40hr or less then anything past 8 daily is overtime. So far
all I get to work is the sum I know not much any help anyone can give me
would be great....thnx