Spreadsheet: 818365d1676769195-i-cant-have-my-formula-to-also-spill-to-other-columns-but-rows-dummydata-helpplease
Sheet: Employees

Name | Days Off | Start of Shift | End of Shift
Employee 1 | Sun,Mon | 07:00:00 | 16:00:00
Employee 2 | Sun,Mon | 07:00:00 | 16:00:00
Employee 3 | Sun,Mon | 07:00:00 | 16:00:00
Employee 4 | Sun,Mon | 07:00:00 | 16:00:00
Employee 5 | Sun,Mon | 07:00:00 | 16:00:00
Employee 6 | Sun,Mon | 07:00:00 | 16:00:00
Employee 7 | Sun,Mon | 07:00:00 | 16:00:00
Employee 8 | Sun,Mon | 07:00:00 | 16:00:00
Employee 9 | Sun,Mon | 07:00:00 | 16:00:00
Employee 10 | Sun,Mon | 07:00:00 | 16:00:00
Employee 11 | Wed,Thu | 10:00:00 | 19:00:00
Employee 12 | Wed,Thu | 10:00:00 | 19:00:00
Employee 13 | Wed,Thu | 10:00:00 | 19:00:00
Employee 14 | Wed,Thu | 10:00:00 | 19:00:00
Employee 15 | Wed,Thu | 10:00:00 | 19:00:00
Employee 16 | Wed,Thu | 10:00:00 | 19:00:00
Employee 17 | Wed,Thu | 10:00:00 | 19:00:00
Employee 18 | Wed,Thu | 10:00:00 | 19:00:00
Employee 19 | Wed,Thu | 10:00:00 | 19:00:00
Employee 20 | Wed,Thu | 10:00:00 | 19:00:00
Employee 21 | Fri,Sat | 14:00:00 | 23:00:00
Employee 22 | Fri,Sat | 14:00:00 | 23:00:00
Employee 23 | Fri,Sat | 14:00:00 | 23:00:00
Employee 24 | Fri,Sat | 14:00:00 | 23:00:00
Employee 25 | Fri,Sat | 14:00:00 | 23:00:00
Employee 26 | Fri,Sat | 14:00:00 | 23:00:00
Employee 27 | Fri,Sat | 14:00:00 | 23:00:00
Employee 28 | Fri,Sat | 14:00:00 | 23:00:00
Employee 29 | Fri,Sat | 14:00:00 | 23:00:00
Employee 30 | Fri,Sat | 14:00:00 | 23:00:00
Employee 31 | Sat,Sun | 11:00:00 | 20:00:00
Employee 32 | Sat,Sun | 11:00:00 | 20:00:00
Employee 33 | Sat,Sun | 11:00:00 | 20:00:00
Employee 34 | Sat,Sun | 11:00:00 | 20:00:00
Employee 35 | Sat,Sun | 11:00:00 | 20:00:00
Employee 36 | Sat,Sun | 11:00:00 | 20:00:00
Employee 37 | Sat,Sun | 11:00:00 | 20:00:00
Employee 38 | Sat,Sun | 11:00:00 | 20:00:00
Employee 39 | Sat,Sun | 11:00:00 | 20:00:00
Employee 40 | Sat,Sun | 11:00:00 | 20:00:00
Employee 41 | Mon,Tue | 09:00:00 | 18:00:00
Employee 42 | Mon,Tue | 09:00:00 | 18:00:00
Employee 43 | Mon,Tue | 09:00:00 | 18:00:00
Employee 44 | Mon,Tue | 09:00:00 | 18:00:00
Employee 45 | Mon,Tue | 09:00:00 | 18:00:00
Employee 46 | Mon,Tue | 09:00:00 | 18:00:00
Employee 47 | Mon,Tue | 09:00:00 | 18:00:00
Employee 48 | Mon,Tue | 09:00:00 | 18:00:00
Employee 49 | Mon,Tue | 09:00:00 | 18:00:00
Employee 50 | Mon,Tue | 09:00:00 | 18:00:00
Employee 51 | Tue,Wed | 12:30:00 | 21:30:00
Employee 52 | Tue,Wed | 12:30:00 | 21:30:00
Employee 53 | Tue,Wed | 12:30:00 | 21:30:00
Employee 54 | Tue,Wed | 12:30:00 | 21:30:00
Employee 55 | Tue,Wed | 12:30:00 | 21:30:00
Employee 56 | Tue,Wed | 12:30:00 | 21:30:00
Employee 57 | Tue,Wed | 12:30:00 | 21:30:00
Employee 58 | Tue,Wed | 12:30:00 | 21:30:00
Employee 59 | Tue,Wed | 12:30:00 | 21:30:00
Employee 60 | Tue,Wed | 12:30:00 | 21:30:00
Employee 61 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 62 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 63 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 64 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 65 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 66 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 67 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 68 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 69 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00
Employee 70 | Thu,[NAME] | 15:00:00 | 1900-01-01 00:00:00