I am currently trying to adjust a formula for our time sheets. The current formula takes into account when a person works over 8 hours to consider that "banked" time (comp time). I now have an employee that will be working 8 hours one day a week and 6 hours the other 4 days. The current formula I am using to account for the days over 8 hours is as follows:
=SUM(IF(M6:M10>"08:00"+0,M6:M10-"08:00"))+SUM(IF(M16:M20>"08:00"+0,M16:M20-"08:00"))+M4+M5+M14+M15
I thought I could change the values for those already in use and make additional for the new as such:
=SUM(IF(M6>"08:00"+0,M6-"08:00"))+SUM(IF(M7:M10>"06:00"+0,M7:M10-"06:00"))+SUM(IF(M16>"08:00"+0,M16-08:00"))+SUM(IF(M17:M20>"06:00"+0,M17:M20-"06:00"))+M4+M5+M14+M15
However, this is not working. How would I write the correct formula for this person?
THANK YOU! Cristal
=SUM(IF(M6:M10>"08:00"+0,M6:M10-"08:00"))+SUM(IF(M16:M20>"08:00"+0,M16:M20-"08:00"))+M4+M5+M14+M15
I thought I could change the values for those already in use and make additional for the new as such:
=SUM(IF(M6>"08:00"+0,M6-"08:00"))+SUM(IF(M7:M10>"06:00"+0,M7:M10-"06:00"))+SUM(IF(M16>"08:00"+0,M16-08:00"))+SUM(IF(M17:M20>"06:00"+0,M17:M20-"06:00"))+M4+M5+M14+M15
However, this is not working. How would I write the correct formula for this person?
THANK YOU! Cristal
