Spreadsheet: 126547d1319740089-if-statement-based-on-cell-data-if-falls-in-range-priority-codes-test
Sheet: Sheet1

Priority | Start Date | Finish Date | Created | Attended | Total Hours | 100 | 200 | 250 | 400
200 | 14 Jan 2011 09:33:29 | 17 Jan 2011 11:50:00 | 2011-01-14 09:33:29 | 2011-01-17 11:50:00 | 26.27527777774958 | 0 | 1 | 0 | 0
200 | 25 Jan 2011 15:20:04 | 27 Jan 2011 14:25:00 | 2011-01-25 15:20:04 | 2011-01-27 14:25:00 | 47.08222222229233 | 0 | 1 | 0 | 0
200 | 13 Jan 2011 16:53:33 | 24 Jan 2011 07:00:00 | 2011-01-13 16:53:33 | 2011-01-24 07:00:00 | 158.1074999998673 | 0 | 0 | 0 | 0
100 | 12 Jan 2011 18:43:01 | 18 Jan 2011 13:00:00 | 2011-01-12 18:43:01 | 2011-01-18 13:00:00 | 90.28305555554107 | 0 | 0 | 0 | 0
100 | 17 Jan 2011 13:34:28 | 18 Jan 2011 13:00:00 | 2011-01-17 13:34:28 | 2011-01-18 13:00:00 | 23.42555555555737 | 1 | 0 | 0 | 0
250 | 14 Jan 2011 08:56:20 | 20 Jan 2011 14:30:00 | 2011-01-14 08:56:20 | 2011-01-20 14:30:00 | 101.5611111110193 | 0 | 0 | 1 | 0
250 | 11 Jan 2011 09:22:08 | 14 Jan 2011 10:20:00 | 2011-01-11 09:22:08 | 2011-01-14 10:20:00 | 72.9644444444566 | 0 | 0 | 1 | 0
100 | 14 Jan 2011 09:40:56 | 17 Jan 2011 00:00:00 | 2011-01-14 09:40:56 | 2011-01-17 00:00:00 | 14.31777777773095 | 1 | 0 | 0 | 0
200 | 14 Jan 2011 10:04:17 | 17 Jan 2011 00:00:00 | 2011-01-14 10:04:17 | 2011-01-17 00:00:00 | 13.9286111110705 | 0 | 1 | 0 | 0
250 | 26 Jan 2011 11:26:19 | 11 Apr 2011 06:30:00 | 2011-01-26 11:26:19 | 2011-04-11 06:30:00 | 1267.061388888862 | 0 | 0 | 0 | 0
200 | 27 Jan 2011 14:14:36 | 31 Jan 2011 14:00:00 | 2011-01-27 14:14:36 | 2011-01-31 14:00:00 | 47.75666666671168 | 0 | 1 | 0 | 0
200 | 13 Jan 2011 08:08:38 | 17 Jan 2011 12:30:00 | 2011-01-13 08:08:38 | 2011-01-17 12:30:00 | 52.3561111111776
300 | 13 Jan 2011 17:15:02 | 20 Jan 2011 09:30:00 | 2011-01-13 17:15:02 | 2011-01-20 09:30:00 | 112.2494444445474
200 | 12 Jan 2011 15:59:01 | 27 Jan 2011 12:20:00 | 2011-01-12 15:59:01 | 2011-01-27 12:20:00 | 260.3497222223086
300 | 12 Jan 2011 21:24:04 | 14 Jan 2011 10:30:00 | 2011-01-12 21:24:04 | 2011-01-14 10:30:00 | 37.09888888889691
200 | 13 Jan 2011 08:39:29 | 14 Jan 2011 13:00:00 | 2011-01-13 08:39:29 | 2011-01-14 13:00:00 | 28.34194444434252
100 | 10 Jan 2011 13:57:48 | 10 Jan 2011 12:00:00 | 2011-01-10 13:57:48 | 2011-01-10 12:00:00 | -1.963333333376795
200 | 14 Jan 2011 14:14:27 | 19 Jan 2011 10:00:00 | 2011-01-14 14:14:27 | 2011-01-19 10:00:00 | 67.7591666666558
250 | 10 Jan 2011 15:29:26 | 31 Jan 2011 13:30:00 | 2011-01-10 15:29:26 | 2011-01-31 13:30:00 | 358.0094444444985
250 | 13 Jan 2011 09:08:17 | 24 Jan 2011 12:05:00 | 2011-01-13 09:08:17 | 2011-01-24 12:05:00 | 170.9452777777333
200 | 13 Jan 2011 10:38:20 | 17 Jan 2011 15:45:00 | 2011-01-13 10:38:20 | 2011-01-17 15:45:00 | 53.11111111112405
200 | 26 Jan 2011 17:11:08 | 02 Feb 2011 08:30:00 | 2011-01-26 17:11:08 | 2011-02-02 08:30:00 | 111.3144444444333
200 | 26 Jan 2011 17:19:23 | 02 Feb 2011 08:30:00 | 2011-01-26 17:19:23 | 2011-02-02 08:30:00 | 111.1769444444217
250 | 10 Jan 2011 16:38:36 | 21 Jan 2011 10:30:00 | 2011-01-10 16:38:36 | 2011-01-21 10:30:00 | 209.8566666666884
250 | 14 Jan 2011 15:49:46 | 20 Jan 2011 09:00:00 | 2011-01-14 15:49:46 | 2011-01-20 09:00:00 | 89.1705555554945
100 | 13 Jan 2011 14:01:38 | 17 Jan 2011 13:50:00 | 2011-01-13 14:01:38 | 2011-01-17 13:50:00 | 47.80611111118924
250 | 27 Jan 2011 09:55:09 | 07 Feb 2011 13:00:00 | 2011-01-27 09:55:09 | 2011-02-07 13:00:00 | 171.0808333331952
250 | 10 Jan 2011 16:56:14 | 13 Jan 2011 08:00:00 | 2011-01-10 16:56:14 | 2011-01-13 08:00:00 | 63.0627777777845
250 | 13 Jan 2011 15:58:44 | 25 Jan 2011 11:00:00 | 2011-01-13 15:58:44 | 2011-01-25 11:00:00 | 187.0211111110984
250 | 27 Jan 2011 11:05:58 | 04 Feb 2011 09:30:00 | 2011-01-27 11:05:58 | 2011-02-04 09:30:00 | 142.4005555555341
200 | 13 Jan 2011 16:08:02 | 14 Jan 2011 12:10:00 | 2011-01-13 16:08:02 | 2011-01-14 12:10:00 | 20.03277777781477
100 | 17 Jan 2011 11:00:20 | 17 Jan 2011 16:00:00 | 2011-01-17 11:00:20 | 2011-01-17 16:00:00 | 4.994444444426335
300 | 15 Jan 2011 13:17:19 | 11 May 2011 11:10:00 | 2011-01-15 13:17:19 | 2011-05-11 11:10:00 | 1965.87805555563
300 | 13 Jan 2011 16:11:00 | 21 Jan 2011 15:00:00 | 2011-01-13 16:11:00 | 2011-01-21 15:00:00 | 142.8166666666511
250 | 13 Jan 2011 17:40:05 | 21 Jan 2011 06:30:00 | 2011-01-13 17:40:05 | 2011-01-21 06:30:00 | 132.831944444566
250 | 27 Jan 2011 11:35:15 | 14 Feb 2011 09:00:00 | 2011-01-27 11:35:15 | 2011-02-14 09:00:00 | 285.4125000000349
300 | 16 Jan 2011 08:32:22 | 20 Jan 2011 15:00:00 | 2011-01-16 08:32:22 | 2011-01-20 15:00:00 | 78.46055555547355
100 | 17 Jan 2011 13:38:13 | 18 Jan 2011 13:00:00 | 2011-01-17 13:38:13 | 2011-01-18 13:00:00 | 23.36305555544095
250 | 17 Jan 2011 08:55:49 | 19 Jan 2011 08:00:00 | 2011-01-17 08:55:49 | 2011-01-19 08:00:00 | 47.0697222223389
300 | 27 Jan 2011 12:51:51 | 07 Feb 2011 13:30:00 | 2011-01-27 12:51:51 | 2011-02-07 13:30:00 | 168.6358333333628
100 | 17 Jan 2011 13:48:15 | 18 Jan 2011 13:00:00 | 2011-01-17 13:48:15 | 2011-01-18 13:00:00 | 23.19583333324408
100 | 13 Jan 2011 17:11:43 | 17 Jan 2011 13:50:00 | 2011-01-13 17:11:43 | 2011-01-17 13:50:00 | 44.63805555563886
200 | 17 Jan 2011 09:20:36 | 18 Jan 2011 08:15:00 | 2011-01-17 09:20:36 | 2011-01-18 08:15:00 | 22.90666666673496
200 | 27 Jan 2011 14:14:36 | 31 Jan 2011 14:00:00 | 2011-01-27 14:14:36 | 2011-01-31 14:00:00 | 47.75666666671168
400 | 11 Jan 2011 11:04:51 | 07 Mar 2011 10:40:00 | 2011-01-11 11:04:51 | 2011-03-07 10:40:00 | 935.5858333334327
300 | 12 Jan 2011 21:10:25 | 14 Jan 2011 10:30:00 | 2011-01-12 21:10:25 | 2011-01-14 10:30:00 | 37.32638888881775
250 | 13 Jan 2011 17:26:37 | 18 Jan 2011 10:00:00 | 2011-01-13 17:26:37 | 2011-01-18 10:00:00 | 64.55638888879912
300 | 27 Jan 2011 16:14:20 | 28 Jan 2011 15:00:00 | 2011-01-27 16:14:20 | 2011-01-28 15:00:00 | 22.76111111103091
250 | 17 Jan 2011 09:39:21 | 31 Jan 2011 10:10:00 | 2011-01-17 09:39:21 | 2011-01-31 10:10:00 | 240.5108333333046