Automated Timecard Calculations - Not adjusting RT and OT

[wheath]

The formulas I have in the sheet were working great, until I worked a day with less than 8 hours. The timecard is not correctly totaling the RT and the OT. I tried changing the formula to take from the total in Column F, which it didnt like because it created a circular logic. Any suggestions?

https://drive.google.com/open?id=0BxlPk4r6K0G9Ulo5ZDdXN3lpN1k

 

[wheath]

<table>
<tr><td>Wolgast Corporation</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>4835 Towne Centre</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Suite 203</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Saginaw</td><td> MI 48604"</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Ph: 989-790-9120 Fx: 989-790-9053</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Employee Name:</td><td></td><td>Wendy Heath</td><td></td><td></td><td>Title:</td><td>Project Manager Assistant</td><td></td><td></td><td></td><td></td></tr>
<tr><td>Employee Number:</td><td></td><td>1781</td><td></td><td></td><td>Status:</td><td>Full-Time Hourly</td><td></td><td></td><td></td><td></td></tr>
<tr><td>Department:</td><td></td><td>Project Management</td><td></td><td></td><td>Supervisor:</td><td>Stephen R. Seibert</td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Date</td><td>Start Time</td><td>Time Out</td><td>Time In</td><td>End Time</td><td>Regular Hours</td><td>OT Hours</td><td>Total Hours</td><td></td><td></td><td></td></tr>
<tr><td>08/01/16</td><td>8:00 AM</td><td>12:40 PM</td><td>1:10 PM</td><td>6:00 PM</td><td>8.00</td><td>1.50</td><td>9.50</td><td></td><td></td><td></td></tr>
<tr><td>08/02/16</td><td>8:00 AM</td><td>1:00 PM</td><td>2:00 PM</td><td>5:30 PM</td><td>8.00</td><td>0.50</td><td>8.50</td><td></td><td></td><td></td></tr>
<tr><td>08/03/16</td><td>8:00 AM</td><td></td><td></td><td>3:30 PM</td><td>7.50</td><td>0.00</td><td>7.50</td><td></td><td></td><td></td></tr>
<tr><td>08/04/16</td><td>8:00 AM</td><td>12:00 PM</td><td>1:00 PM</td><td>5:00 PM</td><td>8.00</td><td>0.00</td><td>8.00</td><td></td><td></td><td></td></tr>
<tr><td>08/05/16</td><td>8:00 AM</td><td></td><td></td><td>5:00 PM</td><td>8.00</td><td>1.00</td><td>9.00</td><td></td><td></td><td></td></tr>
<tr><td>WEEKLY TOTALS</td><td></td><td></td><td></td><td></td><td>39.50</td><td>3.00</td><td>42.50</td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Comments:</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Employee Signature:</td><td></td><td></td><td></td><td></td><td></td><td></td><td>Date:</td><td>08/05/16</td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>Supervisor Signature:</td><td></td><td></td><td></td><td></td><td></td><td></td><td>Date:</td><td></td><td></td><td></td></tr>
</table>