I'm not sure this is what I am looking for. I need the OT to be calculated
daily instead of weekly. The OT is based on 8 hour days. In my example, the
total should be 38 regular hours and 8 OT hours - whereas if it was based on
a weekly 40 hours it would have been 40 regular hours, 6 OT hours.

Basically, I need a way to sum everything over 8 hours, subtracting 8 hours
from each instance.

"Mike H" wrote:

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?