Believe you have Shane's formula below in C2, copied down:
=SUMIF($A$2:$A2,A2,B$2:B2)

So, if you want to calc the OT (ie total hours 40 per date) if any,
for each date in A2 down, let's just use col D

Put in D2: =IF(SUMIF(A:A,A2,B:B)40,SUMIF(A:A,A2,B:B),"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Griffey5" wrote:
I have one other question for this formula. I want to be able to calculate
(in column "C") if the hours are over 40 for each day after it calculates the
hours in column "B"