One way, to get OT hours

=SUMPRODUCT((A2:A640)*(A2:A6-40))

to get regular hours

=SUM(A2:A6)-SUMPRODUCT((A2:A640)*(A2:A6-40))

you should replace SUMPRODUCT((A2:A640)*(A2:A6-40))
in the second formula with the cell holding the OT formula

so if the OT formula is in B3, in B2 use

=SUM(A2:A6)-B3

Regards,

Peo Sjoblom


"ber_harris" wrote:

I have a spreadsheet listing employee hours per week. I want to create a
formula that will total up the total regular hours and the overtime hours
seperately. I would like the spreadsheet to total the 118 regular hours and
then the 2 overtime hours in the cell underneath. I hope this makes sense.
Thanks in advance for you assistance.

Sarah
40
38
42

Total Regular Hours 118
Total Overtime Hours 2