Day | Date | In | Out | In | Out | In | Out | REG | OT |
Sunday | 21-Aug | 8:00 | 16:00 | 8.00 | 0.00 | ||||
Monday | 22-Aug | 8:00 | 12:00 | 12:30 | 17:00 | 8.00 | 0.50 | ||
Tuesday | 23-Aug | 8:00 | 12:00 | 12:30 | 17:00 | 8.00 | 0.50 | ||
Wednesday | 24-Aug | 8:00 | 12:00 | 12:30 | 17:00 | 8.00 | 0.50 | ||
Thursday | 25-Aug | 8:00 | 12:00 | 12:30 | 17:00 | 8.00 | 0.50 | ||
Friday | 26-Aug | 8:00 | 12:00 | 12:30 | 17:00 | 8.00 | 0.50 | ||
Saturday | 27-Aug | 8:00 | 16:00 | 8.00 | 0.00 |
<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>
</tbody>
Reg | OT | Hol | PTO | |
Week 1 | 32.00 | 0.00 | 0.00 | 1.00 |
Week 2 | 56.00 | 2.50 | 0.00 | 0.00 |
Week 3 | 16.00 | 0.00 | 0.00 | 0.00 |
104.00 | 2.50 | 0.00 | 1.00 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:1735; width:37pt" width="49" span="5"> </colgroup><tbody>
</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!