This one worked the best because the other ones were counting my 0's as
negative numbers, etc. (For overtime hours:
=SUMIF(A1:E1,"8")-(COUNTIF(A1:E1,"8")*8)
Thanks so much!


"Teethless mama" wrote:

For regular hours:
=SUM(A1:E1)-(SUMIF(A1:E1,"8")-(COUNTIF(A1:E1,"8")*8))

For overtime hours:
=SUMIF(A1:E1,"8")-(COUNTIF(A1:E1,"8")*8)

Just press ENTER


"Keep It Simple Stupid" wrote:

I need to keep my columns to a minimum.

There are 5 columns for each employee (Monday-Friday). Overtime is
calculated over 8 hours and I need to track how much total regular time &
over time for each employee for each month.

I want some kind of sum if forumula that will calculate everything over 8
and everything under 8.

Mon Tue Wed Thu Fri
8 10 12 6 10 Should be 38 regular hrs, 8
Overtime Hrs (employees will not always have at least 8 hours)

I've tried max/min formulas but not sure how I can do it with keeping my
columns/rows to a minmum. Any ideas?