chadlaw32
Board Regular
- Joined
- Jul 29, 2014
- Messages
- 84
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I need to look up the sup total or Over time based on the name. Example i want to put Doe, John in a cell and have it bring me 0.77, any ideas?
<colgroup><col><col span="4"><col><col><col span="3"><col><col span="3"><col><col span="2"><col></colgroup><tbody>
</tbody>
Pay Date | Pay Code | Hours | Dollars | ||||||||||||||
Doe | Jane | YG6001144 | |||||||||||||||
Sun 03/31/2019 | REGULAR-Regular | 0.27 | XXXX | ||||||||||||||
Mon 04/01/2019 | REGULAR-Regular | 7.37 | XXXX | ||||||||||||||
Tue 04/02/2019 | REGULAR-Regular | 8.28 | XXXX | ||||||||||||||
Wed 04/03/2019 | REGULAR-Regular | 7.83 | XXXX | ||||||||||||||
Thu 04/04/2019 | VACATION-VACATION | 8 | XXXX | ||||||||||||||
Fri 04/05/2019 | REGULAR-Regular | 4.87 | XXXX | ||||||||||||||
Subtotal | 36.62 | XXXX | |||||||||||||||
Doe | John | YG6001457 | |||||||||||||||
Mon 04/01/2019 | REGULAR-Regular | 7.05 | XXXX | ||||||||||||||
Tue 04/02/2019 | REGULAR-Regular | 7.65 | XXXX | ||||||||||||||
Wed 04/03/2019 | REGULAR-Regular | 8.37 | XXXX | ||||||||||||||
Thu 04/04/2019 | REGULAR-Regular | 9.35 | XXXX | ||||||||||||||
Fri 04/05/2019 | OVERTIME-Overtime | 0.77 | XXXX | ||||||||||||||
Fri 04/05/2019 | REGULAR-Regular | 7.58 | XXXX | ||||||||||||||
Subtotal | 40.77 | XXXX | |||||||||||||||
<colgroup><col><col span="4"><col><col><col span="3"><col><col span="3"><col><col span="2"><col></colgroup><tbody>
</tbody>