Spreadsheet: 67898d1268408052-editing-a-formula-that-automatically-calculates-shift-length-lengjay-wc150310a
Sheet: ROTA

 | Week Commencing
 | 2010-03-15 00:00:00 |  |  | 0.02083333333333333 |  | 1
 | Managers | Mon | 2010-03-15 00:00:00 |  | Tue | 2010-03-16 00:00:00 |  | Wed | 2010-03-17 00:00:00 |  | Thu | 2010-03-18 00:00:00 |  | Fri | 2010-03-19 00:00:00 |  | Sat | 2010-03-20 00:00:00 |  | Sun | 2010-03-21 00:00:00 |  | Total |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 | [NAME] | N | F | 0 | N | N | 0 | H | H | 0 | H | H | 0 | H | H | 0 | H | H | 0 | H | H | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 60 | 90 | 120 | 150 | 180 | 210 | 240 | 270 | 300 | 330 | 360 | 390 | 420 | 450 | 480 | 510 | 540 | 570 | 600 | 630 | 660 | 690 | 720 | 750 | 780 | 810 | 840 | 870 | 900 | 930 | 960 | 990 | 1020 | 1050 | 1080 | 1110 | 1140 | 1170 | 1200 | 1230 | 1260 | 1290 | 1320 | 1350 | 1380 | 1410
 | [NAME] | 06:00:00 | F | 12.5 | 15:00:00 | F | 8.5 | T | T | 0 | N | N | 0 | 16:00:00 | 02:00:00 | 9.500000000000002 | 14:00:00 | 02:00:00 | 11.5 | N | N | 0 | 42 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1440 | 1470 | 1500 | 1530 | 1560 | 1590 | 1620 | 1650 | 1680 | 1710 | 1740 | 1770 | 1800
 | Kayleigh | 06:00:00 | 01:00:00 | 18.5 | N | N | 0 | T | T | 0 | 06:00:00 | 15:00:00 | 8.5 | 14:00:00 | 02:00:00 | 11.5 | 15:00:00 | 02:00:00 | 10.5 | 15:00:00 | 01:00:00 | 9.5 | 58.5
 | Martin | N | N | 0 | H | H | 0 | H | H | 0 | H | H | 0 | H | H | 0 | N | N | 0 | N | N | 0 | 0
 | Rich | 15:00:00 | 01:00:00 | 9.5 | N | N | 0 | 15:00:00 | 01:00:00 | 9.5 | N | N | 0 | 06:00:00 | 16:00:00 | 9.5 | 06:00:00 | 17:00:00 | 10.5 | 07:00:00 | 16:00:00 | 8.5 | 47.5
 | Select Finish Time |  | 19:00:00
 |  |  |  | 40.5 |  |  | 8.5 | 07:00:00 | 19:00:00 | 9.5 | 12:00:00 | 1900-01-01 00:00:00 | 8.5 |  |  | 30.5 |  |  | 32.5 |  |  | 18 | 148 |  | 202
 | Kitchen | Mon | 2010-03-15 00:00:00 |  | Tue | 2010-03-16 00:00:00 |  | Wed | 2010-03-17 00:00:00 |  | Thu | 2010-03-18 00:00:00 |  | Fri | 2010-03-19 00:00:00 |  | Sat | 2010-03-20 00:00:00 |  | Sun | 2010-03-21 00:00:00 |  | Total
 | [NAME] | 09:00:00 | 12:00:00 | 3 | H | H | 0 | H | H | 0 | H | H | 0 | H | H | 0 | N | N | 0 | N | N | 0 | 3
 | [NAME] | N | N | 0 | N | N | 0 | N | N | 0 | 15:00:00 | 22:00:00 | 6.5 | 14:00:00 | 22:00:00 | 7.499999999999998 |  |  | 0 | 15:00:00 | 22:00:00 | 6.5 | 20.5
 | Alistair | N | N | 0 | 06:00:00 | 14:00:00 | 7.500000000000002 | 07:00:00 | 14:00:00 | 6.500000000000001 | 06:00:00 | 14:00:00 | 7.500000000000002 | B | B | 0 | 14:00:00 | 22:00:00 | 7.499999999999998 | N | N | 0 | 29
 | Scott | 14:00:00 | 22:00:00 | 7.499999999999998 | 14:00:00 | 22:00:00 | 7.499999999999998 | N | N | 0 | 17:30:00 | 22:00:00 | 4.5 | N | N | 0 | N | N | 0 | 07:00:00 | 17:30:00 | 10 | 29.5
 | [NAME] | 07:00:00 | 14:00:00 | 6.500000000000001 | 17:30:00 | 22:00:00 | 4.5 | 12:00:00 | 22:00:00 | 9.5 | N | N | 0 | N | N | 0 | 06:00:00 | 18:00:00 | 11.5 | 10:00:00 | 16:00:00 | 5.749999999999997 | 37.75
 | Becky | B | B | 0 | 10:00:00 | 16:00:00 | 5.749999999999997 | N | N | 0 | N | N | 0 | 11:00:00 | 18:00:00 | 6.500000000000001 | N | N | 0 | B | B | 0 | 12.25
 | [NAME] | 11:00:00 | 18:00:00 | 6.500000000000001 | N | N | 0 | B | B | 0 | N | N | 0 | B | B | 0 | 10:00:00 | 16:00:00 | 5.749999999999997 | N | N | 0 | 12.25
 | Rohit | 18:00:00 | 22:00:00 | 3.999999999999999 | N | N | 0 | 17:30:00 | 22:00:00 | 4.5 | 10:00:00 | 16:00:00 | 5.749999999999997 | 07:00:00 | 14:00:00 | 6.500000000000001 | N | N | 0 | 17:30:00 | 22:00:00 | 4.5 | 25.25
 | Select Finish Time
 |  |  |  | 27.5 |  |  | 25.25 |  |  | 20.5 |  |  | 24.25 |  |  | 20.5 |  |  | 24.75 |  |  | 26.75 | 169.5 |  | 169.5
 | Forecast Bar |  |  | 1900 |  |  | 2100 |  |  | 2100 |  |  | 2200 |  |  | 4500 |  |  | 4700 |  |  | 2000 | 19500
 | Forecast Food |  |  | 600 |  |  | 850 |  |  | 850 |  |  | 1000 |  |  | 1100 |  |  | 1100 |  |  | 1000 | 6500
 | Total |  |  | 2500 |  |  | 2950 |  |  | 2950 |  |  | 3200 |  |  | 5600 |  |  | 5800 |  |  | 3000 | 26000
 | Associate Hours |  |  | 59.75 |  |  | 58.5 |  |  | 55.25 |  |  | 58 |  |  | 73.5 |  |  | 78.5 |  |  | 58.24999999999999 | 441.75
 | DJ Fees |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Cleaners |  |  | 275 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275
 | Windows |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 | Door Amounts |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 111.1 |  |  | 111.1 |  |  | 0 | 222.2
 | Door Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | 11 |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 643.75
 | Week Commencing
 | 2010-03-15 00:00:00
 | Bar | Mon | 2010-03-15 00:00:00 |  | Tue | 2010-03-16 00:00:00 |  | Wed | 2010-03-17 00:00:00 |  | Thu | 2010-03-18 00:00:00 |  | Fri | 2010-03-19 00:00:00 |  | Sat | 2010-03-20 00:00:00 |  | Sun | 2010-03-21 00:00:00 |  | Total
 | Ellis | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | 12:00:00 | 20:00:00 | 7.500000000000002 | 12:00:00 | 1900-01-01 00:00:00 | 11.5 | 18:30:00 | 01:00:00 | 6.249999999999998 | 25.25
 | [NAME] | N | N | 0 | 10:00:00 | 14:00:00 | 4 | 10:00:00 | 14:00:00 | 4 | 10:00:00 | 14:00:00 | 4 | 10:00:00 | 14:00:00 | 4 | N | N | 0 | N | N | 0 | 16
 | [NAME] | 09:00:00 | 15:30:00 | 6.25 | 08:30:00 | 15:00:00 | 6.249999999999999 | 18:00:00 | 01:00:00 | 6.5 | N | N | 0 | 08:30:00 | 15:00:00 | 6.249999999999999 | 14:00:00 | 02:00:00 | 11.5 | 15:00:00 | 21:00:00 | 5.749999999999999 | 42.5
 | Connah | 20:30:00 | 01:00:00 | 4.5 | N | N | 0 | 14:00:00 | 01:00:00 | 10.5 | 18:00:00 | 01:00:00 | 6.5 | N | N | 0 | 08:00:00 | 15:00:00 | 6.500000000000001 | 09:00:00 | 15:00:00 | 5.749999999999999 | 33.75
 | [NAME] | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | 18:00:00 | 02:00:00 | 7.500000000000002 | 17:00:00 | 1900-01-01 00:00:00 | 6.5 | 12:00:00 | 17:00:00 | 4.75 | 18.75
 | Maya | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | N | N | 0 | 0
 | [NAME] | 15:00:00 | 01:00:00 | 9.5 | 17:00:00 | 01:00:00 | 7.499999999999998 | N | N | 0 | 15:00:00 | 20:00:00 | 4.75 | N | N | 0 | 20:00:00 | 02:00:00 | 5.749999999999999 | H | H | 0 | 27.5
 | Becky | 11:00:00 | 17:00:00 | 5.75 | K | K | 0 | N | N | 0 | N | N | 0 | K | K | 0 | N | N | 0 | N | N | 0 | 5.75
 | Sumith | N | N | 0 | N | N | 0 | 18:00:00 | 22:00:00 | 3.999999999999999 | 16:00:00 | 22:00:00 | 5.749999999999999 | 20:00:00 | 02:00:00 | 5.749999999999999 | 10:00:00 | 16:30:00 | 6.249999999999999 | N | N | 0 | 21.75
 | Shashika | N | N | 0 | 17:00:00 | 01:00:00 | 7.499999999999998 | N | N | 0 | N | N | 0 | N | N | 0 | 20:00:00 | 02:00:00 | 5.749999999999999 | 14:00:00 | 18:30:00 | 4.5 | 17.75
 | [NAME] | N | N | 0 | N | N | 0 | N | N | 0 | 18:00:00 | 01:00:00 | 6.5 | N | N | 0 | N | N | 0 | 20:30:00 | 01:00:00 | 4.5 | 11
 | Rich R | 15:30:00 | 22:00:00 | 6.249999999999998 | 12:00:00 | 20:30:00 | 8 | 09:00:00 | 15:00:00 | 5.749999999999999 | 08:30:00 | 15:00:00 | 6.249999999999999 | 18:00:00 | 02:00:00 | 7.500000000000002 | N | N | 0 | N | N | 0 | 33.75
 | [NAME] | K | K | 0 | N | N | 0 | 19:00:00 | 23:00:00 | 4.000000000000002 | N | N | 0 | 20:00:00 | 1900-01-01 00:00:00 | 3.999999999999999 | K | K | 0 | N | N | 0 | 8
 | Alistair | N | N | 0 | K | K | 0 | K | K | 0 | K | K | 0 | 15:00:00 | 02:00:00 | 10.5 | K | K | 0 | N | N | 0 | 10.5
 | Select Finish Time
 |  |  |  | 32.25 |  |  | 33.25 |  |  | 34.75 |  |  | 33.75 |  |  | 53 |  |  | 53.75 |  |  | 31.5 | 272.25 |  | 272.25
 |  |  |  | 6.249999999999998 |  |  | 15.5 |  |  | 13.75 |  |  | 18.5 |  |  | 27.75 |  |  | 12 |  |  | 9 | 102.75