<colgroup><col style="mso-width-source:userset;mso-width-alt:2645;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:1735; width:37pt" width="49" span="9"> </colgroup><tbody>
[TD="class: xl70, width: 74"]Day[/TD]
[TD="class: xl70, width: 49"]Date[/TD]
[TD="class: xl71, width: 49"]In[/TD]
[TD="class: xl72, width: 49"]Out[/TD]
[TD="class: xl72, width: 49"]In[/TD]
[TD="class: xl72, width: 49"]Out[/TD]
[TD="class: xl72, width: 49"]In[/TD]
[TD="class: xl73, width: 49"]Out[/TD]
[TD="class: xl74, width: 49"]REG[/TD]
[TD="class: xl75, width: 49"]OT[/TD]
[TD="class: xl76"]Sunday[/TD]
[TD="class: xl77"]21-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"]16:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.00[/TD]
[TD="class: xl76"]Monday[/TD]
[TD="class: xl77"]22-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"]12:00[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl66"]17:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.50[/TD]
[TD="class: xl76"]Tuesday[/TD]
[TD="class: xl77"]23-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"]12:00[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl66"]17:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.50[/TD]
[TD="class: xl76"]Wednesday[/TD]
[TD="class: xl77"]24-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"]12:00[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl66"]17:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.50[/TD]
[TD="class: xl76"]Thursday[/TD]
[TD="class: xl77"]25-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"]12:00[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl66"]17:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.50[/TD]
[TD="class: xl76"]Friday[/TD]
[TD="class: xl77"]26-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"]12:00[/TD]
[TD="class: xl66"]12:30[/TD]
[TD="class: xl66"]17:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.50[/TD]
[TD="class: xl76"]Saturday[/TD]
[TD="class: xl77"]27-Aug[/TD]
[TD="class: xl65"]8:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"]16:00[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"]8.00[/TD]
[TD="class: xl69"]0.00[/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:1735; width:37pt" width="49" span="5"> </colgroup><tbody>
[TD="class: xl65, width: 49"][/TD]
[TD="class: xl65, width: 49"]Reg[/TD]
[TD="class: xl65, width: 49"]OT[/TD]
[TD="class: xl65, width: 49"]Hol[/TD]
[TD="class: xl65, width: 49"]PTO[/TD]
[TD="class: xl65"]Week 1[/TD]
[TD="class: xl66, align: right"]32.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl66, align: right"]1.00[/TD]
[TD="class: xl65"]Week 2[/TD]
[TD="class: xl66, align: right"]56.00[/TD]
[TD="class: xl66, align: right"]2.50[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl65"]Week 3[/TD]
[TD="class: xl66, align: right"]16.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl66, align: right"]0.00[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl67, align: right"]104.00[/TD]
[TD="class: xl67, align: right"]2.50[/TD]
[TD="class: xl67, align: right"]0.00[/TD]
[TD="class: xl67, align: right"]1.00[/TD]
</tbody>
Above is week two of a time-sheet. I need the bottom to take anything over 40 hours and move it into the Overtime column. So I think I need a formula for both columns I've tried some, searched a lot but can't quite figure out what to do. Any help would be appreciated, THANK YOU!
