Spreadsheet: 782853d1654333201-help-need-to-remove-multiple-nested-if-statements-2022-06-04-oeldere-beeno-timesheet
Sheet: Pers C

Person C
Timesheet
 | 2022-01-01 00:00:00 |  |  |  |  | 2022-02-01 00:00:00 |  |  |  |  | 2022-03-01 00:00:00
Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time |  | Comment
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 9
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 10 |  |  |  | 0800 - 1700 | 8.5
 |  | 0800 - 1700 | 0 | Public Holiday |  |  | 0800 - 1700 | 8.5 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | Leave
 |  | 0800 - 1700 | 0 | Leave
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 8.5
 |  |  |  |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 9
 |  |  |  |  |  |  | 0800 - 1700 | 9.5 |  |  |  | 0800 - 1700 | 8.5
 |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 0 | Leave
 |  | 0800 - 1700 | 9 |  |  |  | `
 |  | 0800 - 1700 | 9.5
 |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 9.5 |  |  |  | 0800 - 1700 | 0 | Public Holiday
 |  |  |  |  |  |  | 0800 - 1700 | 8.5 |  |  |  | 0800 - 1700 | 9.5
 |  |  |  |  |  |  | 0800 - 1700 | 8.5 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 9.5 |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 10
 |  | 0800 - 1700 | 9.5 |  |  |  | 0800 - 1700 | 7 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 8.5
 |  | 0800 - 1700 | 0 | Leave
 |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 1 | AWW
 |  |  |  |  |  |  | 0800 - 1700 | 8.5 |  |  |  | 0800 - 1700 | 8
 |  |  |  |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | AWW |  |  | 0800 - 1700 | 0 | AWW |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | Public Holiday
 |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 0800 - 1700 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 0800 - 1700 | 9
 |  | 0800 - 1700 | 8 |  |  |  |  |  |  |  |  | 0800 - 1700 | 9
 | 2022-04-01 00:00:00 |  |  |  |  | 2022-05-01 00:00:00 |  |  |  |  | 2022-06-01 00:00:00
Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment
 |  | 0800 - 1700 | 8 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 8.5 |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 6 |  |  |  | 0800 - 1700 | 8.5
 |  | 0800 - 1700 | 0 | Seminar |  |  | 0800 - 1700 | 8.5
 |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 9.5 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 9 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 9
 |  | 0800 - 1700 | 5 | 4 hours sick leave |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700 | 7.5 |  |  |  | 0800 - 1700 | 0 | Public Holiday
 |  | 0800 - 1700 | 8.5 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Public Holiday |  |  |  |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 8 |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700 | 0 | AWW
 |  | 0800 - 1700 | 0 | Public Holiday |  |  | 0800 - 1700 | 8
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 7
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 0 | AWW |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | AWW |  |  |  |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Public Holiday |  |  | 0800 - 1700
 |  | 0800 - 1700 | 9 |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 10 |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 9 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 8 |  |  |  |  |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 | 0 | Public Holiday |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700
 | 2022-07-01 00:00:00 |  |  |  |  | 2022-08-01 00:00:00 |  |  |  |  | 2022-09-01 00:00:00
Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 0 | AWW
 |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 | 0 | AWW |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | Leave |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700
Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment | Day | Date | Start Time - Finish Time | Hours Worked | Comment
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 0 | AWW
 |  | 0800 - 1700 | 0 | Public Holiday |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 0 | AWW
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 | 0 | AWW |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700 | 0 | Public Holiday
 |  | 0800 - 1700 |  |  |  |  |  |  |  |  |  | 0800 - 1700 | 0 | Public Holiday
 |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700
 |  |  |  |  |  |  | 0800 - 1700 |  |  |  |  | 0800 - 1700 | 0 | AWW
 |  | 0800 - 1700