Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula help
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 |