I am trying to calculate union hours on a time sheet and sum total hours,
straight time and then over time all separate. Straight time is based on 8
hours per day instead of 40 hours per week. I've tried an "if" that says if
the range (being mon-fri) is less than or equal to 8, then sum the range.
The problem is that doesn't take into account the days that are over 8 and
does not include those 8 hours. What formula am I missing that says to
include those 8 hours in the sum and then calculate the number of hours that
are over 8? Thanks!
--
Gracie