Hi I have been trying to figure this out for weeks. I need my total daily hours in my regular hours column to only calculate up to 40 hours then anything over 40 hours to total in in the overtime cell. Right now it just totals the total work hours worked for a day in the regular hours, but I only want it to do up to 40 hours that way it only reflects regular hours then anything over that totaled in the overtime hours cell.
|12||Monday||04/23/18||8:00 AM||12:00 PM||1:00 PM||4:30 PM||7.50|
|13||Tuesday||04/24/18||8:00 AM||12:00 PM||1:00 PM||5:30 PM||8.50|
|14||Wednesday||04/25/18||8:00 AM||12:00 PM||1:00 PM||5:00 PM||8.00|
|15||Thursday||04/26/18||8:00 AM||12:00 PM||1:00 PM||5:00 PM||8.00|
|16||Friday||04/27/18||8:00 AM||12:00 PM||1:00 PM||5:15 PM||8.25|