Hi,

For basic hours
=MIN(SUM(A2:E2),38)

For ot hours
=MAX(SUM(A2:E2)-38,0)


Mike


"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?