Spreadsheet: 839756d1692198910-multiple-formatting-with-multiple-conditions-book1
Sheet: Data

device.id | Location | returnToSourceTime | returnLocation | ReturnDuration(minutes) | departFromSourceTime | SourceLocation | TripDuration(minutes) | UNIT_NO | DepartFromSourceYear | DepartFromSourceMonth | DepartFromSourceDay | departFromHaulage | arriveToHaulageTime | departFromHaulage (Month Index) | departFromHaulage (Month) | TimeSpentAtPRO(minutes)
b1156 | 130 King Road | 2023-08-01 01:39:51.647000 | 1 Queen Pl | 29 | 2023-08-01 00:12:59.757000 | 188 3rd St | 27 | 206099 | 2023 | 8 | 1 | 45139.04897804784 | 45139.02711346451 | 8 | Aug | 31
b33C | 130 King Road | 2023-08-01 01:53:29.707000 | 50 16th Dr | 37 | 2023-08-01 00:15:06.043000 | 50 16th Dr | 22 | 206089 | 2023 | 8 | 1 | 45139.05302862654 | 45139.02618850308 | 8 | Aug | 39
b893 | 130 King Road | 2023-08-01 02:24:06.753000 | 188 3rd St | 40 | 2023-08-01 00:15:08.783000 | 188 3rd St | 26 | 206096 | 2023 | 8 | 1 | 45139.07228016976 | 45139.02869533179 | 8 | Aug | 63
b8EA | 130 King Road | 2023-08-01 02:17:48.597000 | 188 3rd St | 27 | 2023-08-01 00:30:40.767000 | 188 3rd St | 46 | 206083 | 2023 | 8 | 1 | 45139.07654031636 | 45139.05285968364 | 8 | Aug | 34
b8F | 130 King Road | 2023-08-01 02:36:55.613000 | 1 Queen Pl | 24 | 2023-08-01 00:45:58.673000 | 188 3rd St | 33 | 206109 | 2023 | 8 | 1 | 45139.09208263889 | 45139.05478225309 | 8 | Aug | 54
bA13 | 130 King Road | 2023-08-01 03:29:14.430000 | 50 16th Dr | 18 | 2023-08-01 02:15:10.877000 | 35 [NAME] | 16 | 206107 | 2023 | 8 | 1 | 45139.13311520062 | 45139.10526462191 | 8 | Aug | 40
b950 | 1122 Front Rd | 2023-08-01 09:13:51.863000 | 188 3rd St | 120 | 2023-08-01 04:58:55.793000 | 188 3rd St | 117 | 206104 | 2023 | 8 | 1 | 45139.30138078704 | 45139.28843136574 | 8 | Aug | 18
b950 | 1122 Front Rd | 2023-08-01 09:13:51.863000 | 188 3rd St | 85 | 2023-08-01 04:58:55.793000 | 188 3rd St | 136 | 206104 | 2023 | 8 | 1 | 45139.32514120371 | 45139.30141165123 | 8 | Aug | 34
b95E | 1122 Front Rd | 2023-08-01 09:48:26.343000 | 50 16th Dr | 72 | 2023-08-01 07:03:30.300000 | 50 16th Dr | 55 | 206095 | 2023 | 8 | 1 | 45139.35859486883 | 45139.33202322531 | 8 | Aug | 38
b8F | 1122 Front Rd | 2023-08-01 12:02:04.133000 | 1 Queen Pl | 88 | 2023-08-01 08:22:50.333000 | 1 Queen Pl | 98 | 206109 | 2023 | 8 | 1 | 45139.44047299383 | 45139.41681712963 | 8 | Aug | 34
b950 | 130 King Road | 2023-08-01 12:41:41.913000 | 188 3rd St | 47 | 2023-08-01 10:46:52.337000 | 188 3rd St | 35 | 206104 | 2023 | 8 | 1 | 45139.49648217593 | 45139.47347013889 | 8 | Aug | 33
b95E | 1122 Front Rd | 2023-08-01 13:45:29.907000 | 50 16th Dr | 67 | 2023-08-01 10:52:40.623000 | 50 16th Dr | 62 | 206095 | 2023 | 8 | 1 | 45139.52680945216 | 45139.49632982253 | 8 | Aug | 44
b8EA | 130 King Road | 2023-08-01 13:08:15.303000 | 188 3rd St | 34 | 2023-08-01 11:19:08.043000 | 188 3rd St | 45 | 206083 | 2023 | 8 | 1 | 45139.52399737654 | 45139.50309486883 | 8 | Aug | 30
b876 | 130 King Road | 2023-08-01 14:01:55.470000 | 3350 Densgrove Park Ave | 28 | 2023-08-01 11:53:02.893000 | 3350 Densgrove Park Ave | 52 | 206097 | 2023 | 8 | 1 | 45139.56493549383 | 45139.53131493056 | 8 | Aug | 48
b34C | 1122 Front Rd | 2023-08-01 15:27:33.787000 | 120 Disco Rd | 60 | 2023-08-01 12:24:48.557000 | 35 [NAME] | 93 | 206077 | 2023 | 8 | 1 | 45139.60270709876 | 45139.5815849537 | 8 | Aug | 30
b1157 | 130 King Road | 2023-08-01 14:41:06.160000 | 1 Queen Pl | 73 | 2023-08-01 12:35:01.803000 | 1 Queen Pl | 53 | 206086 | 2023 | 8 | 1 | 45139.56153703704 | 45139.56145771605 | 8 | Aug | 0
b1157 | 130 King Road | 2023-08-01 14:41:06.160000 | 1 Queen Pl | 40 | 2023-08-01 12:35:01.803000 | 1 Queen Pl | 55 | 206086 | 2023 | 8 | 1 | 45139.58430933642 | 45139.56302731481 | 8 | Aug | 31
b90B | 130 King Road | 2023-08-01 14:51:39.513000 | 120 Disco Rd | 61 | 2023-08-01 13:21:59.300000 | 120 Disco Rd | 27 | 206106 | 2023 | 8 | 1 | 45139.57656558642 | 45139.57545879629 | 8 | Aug | 2
b90B | 130 King Road | 2023-08-01 14:51:39.513000 | 120 Disco Rd | 19 | 2023-08-01 13:21:59.300000 | 120 Disco Rd | 29 | 206106 | 2023 | 8 | 1 | 45139.60579606482 | 45139.57702665895 | 8 | Aug | 42
b8EA | 130 King Road | 2023-08-01 16:06:36.987000 | 188 3rd St | 48 | 2023-08-01 14:07:46.047000 | 188 3rd St | 43 | 206083 | 2023 | 8 | 1 | 45139.6375126929 | 45139.61817565587 | 8 | Aug | 28
b338 | 130 King Road | 2023-08-01 17:49:24.367000 | 50 16th Dr | 36 | 2023-08-01 15:49:07.387000 | 50 16th Dr | 32 | 206078 | 2023 | 8 | 1 | 45139.7176595679 | 45139.68151655093 | 8 | Aug | 52
b8EA | 130 King Road | 2023-08-01 19:33:22.633000 | 188 3rd St | 36 | 2023-08-01 17:19:16.930000 | 188 3rd St | 69 | 206083 | 2023 | 8 | 1 | 45139.78999363426 | 45139.77007623457 | 8 | Aug | 29
b30F | 130 King Road | 2023-08-01 19:52:26.257000 | 50 16th Dr | 25 | 2023-08-01 18:25:50.700000 | 50 16th Dr | 24 | 206101 | 2023 | 8 | 1 | 45139.81084189815 | 45139.78433167438 | 8 | Aug | 38
b1156 | 130 King Road | 2023-08-01 21:03:46.737000 | 1 Queen Pl | 30 | 2023-08-01 19:06:43.563000 | 1 Queen Pl | 54 | 206099 | 2023 | 8 | 1 | 45139.85637010031 | 45139.83399216821 | 8 | Aug | 33
bA13 | 130 King Road | 2023-08-01 20:36:10.650000 | 50 16th Dr | 52 | 2023-08-01 19:09:01.573000 | 50 16th Dr | 29 | 206107 | 2023 | 8 | 1 | 45139.82255979938 | 45139.81817137346 | 8 | Aug | 6
bA13 | 130 King Road | 2023-08-01 20:36:10.650000 | 50 16th Dr | 24 | 2023-08-01 19:09:01.573000 | 50 16th Dr | 61 | 206107 | 2023 | 8 | 1 | 45139.84215474537 | 45139.84085871914 | 8 | Aug | 2
b8F4 | 130 King Road | 2023-08-01 22:07:02.207000 | 188 3rd St | 26 | 2023-08-01 20:35:27.667000 | 1 Queen Pl | 30 | 206108 | 2023 | 8 | 1 | 45139.90355173611 | 45139.87847712191 | 8 | Aug | 36
b8EA | 130 King Road | 2023-08-01 22:09:34.727000 | 188 3rd St | 26 | 2023-08-01 20:47:52.453000 | 188 3rd St | 28 | 206083 | 2023 | 8 | 1 | 45139.90553680556 | 45139.88570524691 | 8 | Aug | 28
b338 | 130 King Road | 2023-08-01 22:33:46.470000 | 50 16th Dr | 16 | 2023-08-01 21:01:03.663000 | 50 16th Dr | 17 | 206078 | 2023 | 8 | 1 | 45139.92900706019 | 45139.88770787037 | 8 | Aug | 59