Adding cell values over set amount.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Range of times in C3:C20.

Want to add only the time greater than 8 hours together.

9.0
8.5
9.0
8.5


formula = (1+.5+1+.5)=3

Tried this, but didnt work.
=IF((C3:C20)>8,(C3:C20)+(-8),0)
 
Try: SUMIF(C3:C20,">8")

You mentioned "hours" but these look like 'normal' numbers not clocktimes
If the times show as 9:00, 8:30, then use
=SUMIF(C3:C20,">"&TIME(8,0,0))
best wishes
 
Back
Top