One way would be to use the following ARRAY Formulas. They must be ntered
with Ctrl+Shift+Enter:

To calculate non-OT:
=SUM(IF(A1:A340,40,A1:A3))

To calculate OT:
=SUM(IF(A1:A340,A1:A3-40))

tj

"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