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

A | Date | Start Time - Finish Time | Hours Worked | Comment | day | week | month | year | start | finisch | Hours
vrijdag | 2022-04-01 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
zaterdag | 2022-04-02 00:00:00
zondag | 2022-04-03 00:00:00
maandag | 2022-04-04 00:00:00 | 0800 - 1700 | 1900-01-06 00:00:00
dinsdag | 2022-04-05 00:00:00 | 0800 - 1700 | 00:00:00 | Seminar
woensdag | 2022-04-06 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
donderdag | 2022-04-07 00:00:00 | 0800 - 1700 | 1900-01-09 12:00:00
vrijdag | 2022-04-08 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
zaterdag | 2022-04-09 00:00:00
zondag | 2022-04-10 00:00:00
maandag | 2022-04-11 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
dinsdag | 2022-04-12 00:00:00 | 0800 - 1700 | 1900-01-05 00:00:00 | 4 hours sick leave
woensdag | 2022-04-13 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
donderdag | 2022-04-14 00:00:00 | 0800 - 1700 | 1900-01-08 12:00:00
vrijdag | 2022-04-15 00:00:00 | 0800 - 1700 | 00:00:00 | Public Holiday
zaterdag | 2022-04-16 00:00:00
zondag | 2022-04-17 00:00:00
maandag | 2022-04-18 00:00:00 | 0800 - 1700 | 00:00:00 | Public Holiday
dinsdag | 2022-04-19 00:00:00 | 0800 - 1700 | 00:00:00 | Leave
woensdag | 2022-04-20 00:00:00 | 0800 - 1700 | 00:00:00 | Leave
donderdag | 2022-04-21 00:00:00 | 0800 - 1700 | 00:00:00 | Leave
vrijdag | 2022-04-22 00:00:00 | 0800 - 1700 | 00:00:00 | AWW
zaterdag | 2022-04-23 00:00:00
zondag | 2022-04-24 00:00:00
maandag | 2022-04-25 00:00:00 | 0800 - 1700 | 00:00:00 | Public Holiday
dinsdag | 2022-04-26 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
woensdag | 2022-04-27 00:00:00 | 0800 - 1700 | 1900-01-10 00:00:00
donderdag | 2022-04-28 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
vrijdag | 2022-04-29 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
zaterdag | 2022-04-30 00:00:00
zondag | 2022-05-01 00:00:00
maandag | 2022-05-02 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
dinsdag | 2022-05-03 00:00:00 | 0800 - 1700 | 1900-01-08 12:00:00
woensdag | 2022-05-04 00:00:00 | 0800 - 1700 | 1900-01-08 12:00:00
donderdag | 2022-05-05 00:00:00 | 0800 - 1700 | 1900-01-08 12:00:00
vrijdag | 2022-05-06 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
zaterdag | 2022-05-07 00:00:00
zondag | 2022-05-08 00:00:00
maandag | 2022-05-09 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
dinsdag | 2022-05-10 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
woensdag | 2022-05-11 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
donderdag | 2022-05-12 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
vrijdag | 2022-05-13 00:00:00 | 0800 - 1700 | 1900-01-07 12:00:00
zaterdag | 2022-05-14 00:00:00
zondag | 2022-05-15 00:00:00
maandag | 2022-05-16 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
dinsdag | 2022-05-17 00:00:00 | 0800 - 1700 | 1900-01-09 00:00:00
woensdag | 2022-05-18 00:00:00 | 0800 - 1700 | 1900-01-08 00:00:00
donderdag | 2022-05-19 00:00:00 | 0800 - 1700 | 1900-01-07 00:00:00
vrijdag | 2022-05-20 00:00:00 | 0800 - 1700 | 00:00:00 | AWW
zaterdag | 2022-05-21 00:00:00
zondag | 2022-05-22 00:00:00
maandag | 2022-05-23 00:00:00 | 0800 - 1700
dinsdag | 2022-05-24 00:00:00 | 0800 - 1700
woensdag | 2022-05-25 00:00:00 | 0800 - 1700
donderdag | 2022-05-26 00:00:00 | 0800 - 1700
vrijdag | 2022-05-27 00:00:00 | 0800 - 1700
zaterdag | 2022-05-28 00:00:00
zondag | 2022-05-29 00:00:00
maandag | 2022-05-30 00:00:00 | 0800 - 1700 | 00:00:00 | Public Holiday
dinsdag | 2022-05-31 00:00:00 | 0800 - 1700
 |  | 0800 - 1700