Spreadsheet: 839950d1692308519-need-formula-to-highlight-hours-out-with-working-arrangement-test-2-dougers1-
Sheet: Sheet1

Date | Grade | From | To | Break | Start | End | Actual Break | Hours
2023-08-17 00:00:00 | StH-LA OW M-F9am-5pm | 09:00:00 | 17:00:00 | 30 | 09:00:00 | 17:00:00 | 30 | 07:30:00 | 1 | Working Arrangements
2023-08-18 00:00:00 | Con 8am-8pm Mon-Fri | 08:00:00 | 16:00:00 | 30 | 08:00:00 | 16:00:00 | 30 | 07:30:00 | 0 | LA Outside Monday to Friday 9am to 5pm for shift working patterns
2023-08-19 00:00:00 | StH-LA OW M-F9am-5pm | 17:00:00 | 21:00:00 | 0 | 17:00:00 | 21:00:00 | 0 | 04:00:00 | 1 | LB  Outside Monday to Friday 9am to 5pm for on-call working patterns
2023-08-20 00:00:00 | StH-LA OW M-F9am-5pm | 08:30:00 | 21:00:00 | 0 | 08:30:00 | 21:00:00 | 0 | 12:30:00 | 1 | LC Monday to Friday 9am to 5pm for all working patterns
2023-08-21 00:00:00 | StL-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 0
2023-08-22 00:00:00 | [NAME] 24Hrs | 08:00:00 | 17:00:00 | 30 | 08:00:00 | 17:00:00 | 30 | 08:30:00 | 0
2023-08-23 00:00:00 | StH-LA OW M-F9am-5pm | 08:30:00 | 16:45:00 | 45 | 08:30:00 | 16:45:00 | 45 | 07:30:00 | 0
2023-08-24 00:00:00 | xStLED SatSun 24 Hrs | 14:00:00 | 22:00:00 | 30 | 14:00:00 | 22:00:00 | 30 | 07:30:00 | 1
2023-08-25 00:00:00 | StL-LA OW M-F9am-5pm | 21:00:00 | 10:00:00 | 45 | 21:00:00 | 10:00:00 | 45 | 12:15:00 | 0
2023-08-17 00:00:00 | StH-LA OW M-F9am-5pm | 20:30:00 | 08:45:00 | 45 | 20:30:00 | 08:45:00 | 45 | 11:30:00 | 0
2023-08-18 00:00:00 | FY2LA O/W M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 0
2023-08-19 00:00:00 | StH-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 1
2023-08-20 00:00:00 | xStLED Mon-Fri 24hrs | 12:00:00 | 20:00:00 | 30 | 12:00:00 | 20:00:00 | 30 | 07:30:00 | 1
2023-08-21 00:00:00 | FY2LA O/W M-F9am-5pm | 08:45:00 | 17:10:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 0
2023-08-22 00:00:00 | StL-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 0
2023-08-23 00:00:00 | StL-LA OW M-F9am-5pm | 20:30:00 | 08:45:00 | 45 | 20:30:00 | 08:45:00 | 45 | 11:30:00 | 0
2023-08-24 00:00:00 | StH-LA OW M-F9am-5pm | 08:00:00 | 17:30:00 | 60 | 08:00:00 | 17:30:00 | 60 | 08:30:00 | 0
2023-08-25 00:00:00 | StL-LA OW M-F9am-5pm | 07:45:00 | 16:30:00 | 30 | 07:45:00 | 16:30:00 | 30 | 08:15:00 | 0
2023-08-26 00:00:00 | StH-LA OW M-F9am-5pm | 17:00:00 | 21:30:00 | 0 | 17:00:00 | 21:30:00 | 0 | 04:30:00 | 1
2023-08-27 00:00:00 | [NAME] 24Hrs | 16:00:00 | 01:00:00 | 30 | 16:00:00 | 01:00:00 | 30 | 08:30:00 | 0
2023-08-28 00:00:00 | StL-LA OW M-F9am-5pm | 08:30:00 | 20:45:00 | 45 | 08:30:00 | 20:45:00 | 45 | 11:30:00 | 0
2023-08-29 00:00:00 | [NAME] 24Hrs | 22:15:00 | 08:15:00 | 45 | 22:15:00 | 08:15:00 | 45 | 09:15:00 | 0
2023-08-30 00:00:00 | StL-LA OW M-F9am-5pm | 10:00:00 | 20:00:00 | 45 | 10:00:00 | 20:00:00 | 45 | 09:15:00 | 0
2023-08-31 00:00:00 | FY2LA O/W M-F9am-5pm | 08:00:00 | 16:30:00 | 30 | 08:00:00 | 16:30:00 | 30 | 08:00:00 | 0
2023-09-01 00:00:00 | StH-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 0
2023-09-02 00:00:00 | FY2LA O/W M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00 | 1
2023-09-03 00:00:00 | [NAME] 24Hrs | 12:00:00 | 22:00:00 | 30 | 12:00:00 | 22:00:00 | 30 | 09:30:00 | 0
2023-09-04 00:00:00 | StL-LA OW M-F9am-5pm | 08:30:00 | 17:00:00 | 45 | 08:30:00 | 20:45:00 | 45 | 11:30:00 | 0
2023-09-05 00:00:00 | StL-LA OW M-F9am-5pm | 21:00:00 | 09:00:00 | 60 | 21:00:00 | 09:00:00 | 60 | 11:00:00 | 0
2023-09-06 00:00:00 | FY2LA O/W M-F9am-5pm | 09:00:00 | 17:00:00 | 30 | 09:00:00 | 17:00:00 | 30 | 07:30:00 | 0
2023-09-07 00:00:00 | Con 8am-8pm Mon-Fri | 09:00:00 | 17:00:00 | 30 | 07:30:00 | 17:00:00 | 30 | 09:00:00 | 0
2023-09-08 00:00:00 | xStLED Mon-Fri 24hrs | 12:00:00 | 23:00:00 | 60 | 12:00:00 | 23:00:00 | 60 | 10:00:00 | 0