Basically, I am trying to do a tracking sheet for hours and the "California
State" Furloughs. If some one works on their Furlough day they should be
entering "FW" into the cell. The totals at the bottom of the page should then
read that FW=8 hours plus any additional time entered for the week. If
someone works over 40 hours then i need to have the weekly total split into
"regular hours" and "overtime hours."
This is what I have
Week 2
August Date REG OT
Sunday 8/2/09
Monday 8/3/09 10.00
Tuesday 8/4/09 10.00
Wednesday 8/5/09 8.00
Thursday 8/6/09 9.00
Friday 8/7/09 FW
Saturday 8/8/09
Total weekly hours 37.00

This is what I need:
Week 2
August Date REG OT
Sunday 8/2/09
Monday 8/3/09 10.00
Tuesday 8/4/09 10.00
Wednesday 8/5/09 8.00
Thursday 8/6/09 9.00
Friday 8/7/09 FW
Saturday 8/8/09
Total weekly hours 40.00 5.00

I am trying to do two things...

1) Convert the sum of a range of cells {=SUM(C1:D15)} to reflect the number
8 if "FW" is typed a cell within that range.
Next,
2) If the formula above is 40 then the cell need to convert over the values
if the above reaches over 40.