Spreadsheet: 705380d1606080231-how-to-change-cell-format-to-something-that-canbe-calculated-delivery-format-
Sheet: deliveries.csv

Order placed | Order rcvd | [NAME] | [NAME] | Driver ID | Site | Consumer ID | Delivery Region | Rush? | Order total | Amount of discount | Amount of tip | Refunded amount
01 00:00:47 | 01 01:44:06 | 01 01:53:24 | 01 02:11:35 | 216 | 59 | 5271 | Palo Alto | False | 32.05 | 0 | 3.21 | 0
01 00:03:15 | 01 00:07:22 |  | 01 00:28:17 | 259 | 83 | 640 | Palo Alto | True | 21.12 | 0 | 1.39 | 0
01 00:03:54 | 01 00:12:37 |  | 01 01:06:19 | 66 | 63 | 25002 | Palo Alto | False | 110.45 | 0 | 14.4 | 0
01 00:04:46 | 01 00:07:26 |  | 01 00:49:43 | 313 | 83 | 9923 | Palo Alto | True | 63.31 | 0 | 3.17 | 0
01 00:04:49 | 01 00:07:40 | 01 00:17:50 | 01 00:46:26 | 133 | 86 | 60072 | Palo Alto | True | 61.98 | 0 | 2.57 | 0
01 00:05:30 | 01 00:06:27 | 01 00:15:30 | 01 01:03:54 | 320 | 20 | 9792 | Palo Alto | True | 126.35 | 0 | 5.25 | 0
01 00:05:57 | 01 00:11:33 | 01 00:20:08 | 01 00:53:00 | 222 | 19 | 2575 | Palo Alto | True | 27.21 | 0 | 0 | 0
01 00:06:02 | 01 00:10:43 | 01 00:19:47 | 01 00:39:50 | 215 | 207 | 607 | Palo Alto | True | 29.82 | 0 | 2.19 | 0
01 00:06:44 | 01 00:11:57 | 01 00:21:08 | 01 00:32:55 | 336 | 182 | 62240 | San Jose | True | 16.74 | 6 | 3 | 0
01 [NAME] | 01 02:14:10 |  | 01 [NAME] | 133 | 94 | 5509 | Palo Alto | False | 48.14 | 0 | 5.81 | 0
01 00:08:49 | 01 00:10:45 | 01 00:27:11 | 01 00:49:16 | 204 | 50 | 1719 | Mountain View | True | 83.32 | 0 | 3.55 | 0
01 00:09:03 | 01 00:13:12 |  | 01 00:47:19 | 282 | 276 | 63401 | San Jose | True | 63.53 | 0 | 2.64 | 0
01 00:10:22 | 01 00:10:49 |  | 01 00:36:41 | 125 | 3 | 1122 | Palo Alto | True | 46.02 | 0 | 2.3 | 0
01 00:10:42 | 01 00:12:09 | 01 00:26:25 | 01 00:50:51 | 215 | 9 | 13787 | Palo Alto | True | 51.68 | 0 | 2.58 | 0
01 00:10:44 | 01 00:13:20 |  | 01 00:58:40 | 109 | 170 | 74944 | San Jose | True | 27.64 | 6 | 3 | 0
01 00:12:05 | 01 00:14:02 | 01 00:22:20 | 01 00:42:48 | 330 | 8 | 3813 | Palo Alto | True | 22.86 | 0 | 3.43 | 0
01 00:12:45 | 01 01:00:38 | 01 01:03:47 | 01 01:31:35 | 324 | 86 | 74993 | Palo Alto | False | 11.86 | 6 | 1 | 0
01 [NAME] | 01 00:14:37 |  | 01 01:00:36 | 304 | 289 | 74970 | San Jose | True | 54.88 | 6 | 2.24 | 0
01 00:12:59 | 01 00:14:00 | 01 00:18:49 | 01 00:57:17 | 198 | 107 | 3669 | Palo Alto | True | 26.66 | 0 | 1.33 | 0
01 00:13:04 | 01 00:15:15 | 01 00:21:10 | 01 [NAME] | 207 | 43 | 3016 | Mountain View | True | 92.52 | 0 | 7.95 | 0
01 00:13:05 | 01 00:14:02 |  | 01 01:19:09 | 195 | 20 | 32411 | Palo Alto | True | 71.03 | 0 | 3.55 | 0
01 00:14:35 | 01 00:15:02 | 01 00:29:57 | 01 00:51:36 | 156 | 48 | 71321 | Palo Alto | True | 44.44 | 0 | 0 | 0
01 00:16:24 | 01 00:17:58 | 01 00:33:43 | 01 00:47:01 | 277 | 62 | 6943 | Palo Alto | True | 19.59 | 0 | 0.98 | 0
01 00:16:48 | 01 00:17:48 | 01 00:32:14 | 01 00:50:17 | 36 | 181 | 26616 | San Jose | True | 47.27 | 0 | 3.79 | 0
01 00:16:51 | 01 01:52:36 | 01 01:40:39 | 01 [NAME] | 34 | 240 | 5709 | Palo Alto | False | 46.62 | 0 | 5.6 | 0
01 00:17:01 | 01 00:17:18 | 01 00:45:35 | 01 01:01:42 | 66 | 41 | 1148 | Palo Alto | True | 78.21 | 0 | 6.64 | 0
01 00:17:59 | 01 00:21:40 |  | 01 01:15:22 | 224 | 72 | 2445 | Palo Alto | True | 47.75 | 0 | 1.91 | 0
01 00:18:53 | 01 00:21:50 | 01 00:46:37 | 01 01:00:54 | 224 | 258 | 58590 | Palo Alto | True | 32.86 | 0 | 3.7 | 0
01 00:19:55 | 01 00:20:06 | 01 00:31:50 | 01 01:01:40 | 48 | 107 | 6163 | Palo Alto | True | 60.27 | 0 | 6.03 | 0
01 00:21:49 | 01 00:22:41 | 01 00:45:35 | 01 01:25:12 | 317 | 170 | 14647 | San Jose | True | 51.4 | 0 | 2.57 | 15
01 00:21:53 | 01 00:22:26 | 01 00:33:15 | 01 01:15:04 | 248 | 98 | 8534 | Mountain View | True | 29.87 | 0 | 0 | 0
01 00:22:49 | 01 00:24:18 | 01 [NAME] | 01 01:18:25 | 166 | 8 | 4187 | Palo Alto | True | 90.78 | 0 | 7.79 | 0
01 00:22:58 | 01 00:23:23 | 01 00:50:07 | 01 00:52:57 | 314 | 63 | 1169 | Palo Alto | False | 77.39 | 0 | 3.28 | 0
01 00:23:50 | 01 00:25:39 |  | 01 00:59:29 | 64 | 109 | 1779 | Palo Alto | True | 58.16 | 0 | 2.39 | 0
01 00:24:46 | 01 00:28:13 | 01 00:39:52 | 01 01:05:18 | 84 | 86 | 3668 | Palo Alto | True | 35.4 | 0 | 4.05 | 0
01 00:25:33 | 01 00:26:36 | 01 00:54:40 | 01 01:15:25 | 259 | 32 | 2704 | Palo Alto | False | 42.27 | 0 | 3.33 | 0
01 00:25:49 | 01 01:01:50 |  | 01 01:36:01 | 154 | 62 | 12579 | Palo Alto | False | 63.53 | 0 | 7.93 | 0
01 00:26:31 | 01 00:35:41 | 01 00:46:59 | 01 01:05:29 | 336 | 135 | 11679 | San Jose | True | 18.51 | 0 | 1.15 | 0
01 00:26:54 | 01 00:39:57 | 01 01:16:25 | 01 01:31:19 | 64 | 77 | 2404 | Mountain View | False | 42.92 | 0 | 2.15 | 0
01 00:26:55 | 01 00:29:21 | 01 00:39:17 | 01 01:02:39 | 287 | 114 | 46287 | Mountain View | True | 36.29 | 0 | 0 | 0
01 [NAME] | 01 00:27:35 | 01 00:54:52 | 01 01:08:19 | 277 | 63 | 12461 | Palo Alto | False | 53.74 | 6 | 0 | 0
01 00:30:29 | 01 00:40:47 | 01 01:08:36 | 01 01:25:50 | 147 | 62 | 3805 | Palo Alto | False | 52.16 | 0 | 7 | 0
01 00:30:42 | 01 00:32:26 | 01 00:49:56 | 01 01:15:02 | 262 | 306 | 967 | Palo Alto | True | 60.48 | 0 | 5.01 | 0
01 00:30:59 | 01 00:34:08 |  | 01 01:37:07 | 274 | 95 | 3605 | Mountain View | False | 80.87 | 0 | 3.44 | 0
01 00:31:06 | 01 00:38:26 | 01 00:45:20 | 01 01:08:13 | 327 | 12 | 36458 | Palo Alto | True | 24.92 | 6 | 1.25 | 0
01 00:31:16 | 01 00:33:00 | 01 00:46:42 | 01 01:07:10 | 24 | 7 | 22580 | Palo Alto | True | 94.63 | 0 | 4.73 | 0
01 00:31:28 | 01 00:35:04 | 01 [NAME] | 01 01:18:54 | 196 | 217 | 8623 | Mountain View | True | 18.43 | 0 | 0.92 | 0
01 00:31:38 | 01 00:32:50 | 01 01:02:48 | 01 01:44:32 | 125 | 107 | 71624 | Palo Alto | True | 142.39 | 6 | 5.99 | 0
01 [NAME] | 01 00:41:17 | 01 01:16:15 | 01 01:42:55 | 41 | 76 | 7418 | Palo Alto | True | 92.57 | 0 | 9.26 | 11.91
01 00:32:42 | 01 00:35:15 | 01 01:08:25 | 01 01:27:04 | 204 | 76 | 6286 | Mountain View | True | 90.44 | 0 | 7.76 | 0
01 00:33:29 | 01 00:39:18 | 01 02:03:46 | 01 04:34:30 | 277 | 8 | 4181 | Palo Alto | False | 84.14 | 0 | 0 | 6
01 00:33:58 | 01 00:38:06 | 01 01:18:27 | 01 01:34:34 | 297 | 32 | 1342 | Mountain View | False | 31.45 | 0 | 1.04 | 0
01 00:34:04 | 01 00:36:23 | 01 00:56:04 | 01 01:26:17 | 216 | 8 | 2743 | Palo Alto | True | 30.41 | 0 | 5 | 0
01 00:34:34 | 01 00:36:26 | 01 00:54:36 | 01 01:28:05 | 133 | 8 | 669 | Palo Alto | True | 24.98 | 0 | 0.87 | 0
01 00:34:49 | 01 00:39:28 |  | 01 00:50:46 | 125 | 83 | 2482 | Palo Alto | True | 28.24 | 0 | 1 | 0
01 00:34:50 | 01 00:45:28 |  | 01 01:15:53 | 308 | 72 | 12034 | Palo Alto | True | 20.66 | 0 | 0 | 0
01 00:35:05 | 01 00:41:59 | 01 00:58:59 | 01 01:20:23 | 325 | 236 | 3630 | Palo Alto | True | 38.05 | 0 | 4.41 | 0
01 00:35:15 | 01 00:46:04 | 01 00:51:11 | 01 01:19:49 | 73 | 216 | 40233 | Mountain View | True | 41.83 | 6 | 2.09 | 0
01 00:35:16 | 01 00:44:15 | 01 00:54:42 | 01 01:25:25 | 279 | 224 | 11357 | Mountain View | True | 56.03 | 0 | 2.8 | 0
01 00:35:51 | 01 00:37:45 | 01 01:09:27 | 01 02:00:22 | 227 | 170 | 75046 | San Jose | True | 27.64 | 6 | 4 | 0
01 00:35:52 | 01 00:49:03 | 01 01:11:40 | 01 01:40:07 | 330 | 252 | 4508 | Palo Alto | True | 30.47 | 0 | 2.25 | 0
01 00:36:20 | 01 00:36:40 |  | 01 01:27:51 | 151 | 20 | 2594 | Palo Alto | True | 21.12 | 0 | 3.17 | 0
01 00:36:41 | 01 00:39:23 |  | 01 01:57:28 | 133 | 8 | 4087 | Palo Alto | False | 66.19 | 0 | 2.76 | 0
01 00:37:00 | 01 00:44:19 | 01 01:05:42 | 01 01:23:18 | 137 | 268 | 9956 | Palo Alto | True | 39.55 | 0 | 1.98 | 0
01 00:37:07 | 01 00:48:36 | 01 01:08:34 | 01 01:43:36 | 151 | 233 | 1925 | Palo Alto | True | 48.51 | 0 | 3.9 | 0
01 00:37:35 | 01 00:48:52 | 01 00:55:22 | 01 01:18:29 | 288 | 72 | 75033 | Palo Alto | True | 43.01 | 6 | 4.3 | 0
01 00:38:16 | 01 00:43:42 | 01 00:57:14 | 01 01:38:06 | 249 | 222 | 23952 | San Jose | True | 22.27 | 0 | 3.34 | 0
01 00:38:34 | 01 00:44:30 | 01 01:02:58 | 01 01:33:41 | 313 | 28 | 10512 | Palo Alto | True | 86.69 | 0 | 3 | 0
01 00:38:34 | 01 [NAME] | 01 00:59:19 | 01 01:16:25 | 73 | 43 | 7920 | Mountain View | True | 24.49 | 0 | 2.45 | 0
01 00:38:37 | 01 01:11:29 | 01 01:59:44 | 01 02:24:40 | 279 | 8 | 75066 | Mountain View | False | 28.24 | 6 | 0 | 0
01 00:40:11 | 01 00:49:49 | 01 01:02:41 | 01 01:22:15 | 207 | 50 | 75062 | Mountain View | True | 20.63 | 6 | 2.01 | 0
01 00:40:50 | 01 00:52:06 | 01 00:58:07 | 01 01:59:33 | 156 | 28 | 9267 | Palo Alto | True | 74.19 | 0 | 6.27 | 0
01 00:40:57 | 01 00:49:42 | 01 01:31:09 | 01 01:47:52 | 216 | 9 | 10634 | Palo Alto | True | 113.06 | 0 | 9.84 | 0
01 00:41:16 | 01 00:45:23 |  | 01 01:20:39 | 282 | 271 | 10378 | San Jose | True | 58.76 | 0 | 4.84 | 0
01 00:42:16 | 01 00:43:42 | 01 01:21:54 | 01 02:00:34 | 299 | 10 | 48555 | Palo Alto | True | 58.2 | 6 | 7.2 | 0
01 00:42:27 | 01 00:44:25 | 01 01:55:43 | 01 02:12:26 | 151 | 10 | 75010 | Palo Alto | True | 144.68 | 6 | 12.2 | 0
01 00:42:59 | 01 00:49:50 | 01 01:16:30 | 01 01:47:31 | 312 | 76 | 8867 | Palo Alto | True | 57.49 | 0 | 2.87 | 0
01 00:43:18 | 01 00:44:07 | 01 01:12:50 | 01 01:59:04 | 222 | 47 | 13680 | Palo Alto | True | 94.41 | 0 | 4.72 | 0
01 00:43:59 | 01 00:54:26 |  | 01 01:26:46 | 340 | 83 | 988 | Palo Alto | True | 34.22 | 0 | 2.59 | 0
01 00:44:02 | 01 01:04:24 | 01 01:21:37 | 01 01:40:28 | 145 | 59 | 3520 | Palo Alto | True | 19.05 | 0 | 0.6 | 0
01 00:44:16 | 01 01:02:10 | 01 01:32:05 | 01 01:46:49 | 288 | 6 | 383 | Palo Alto | True | 34.22 | 0 | 5.13 | 0
01 00:44:40 | 01 00:47:30 | 01 01:24:37 | 01 01:45:28 | 69 | 169 | 12905 | San Jose | True | 53.2 | 6 | 2.66 | 0
01 00:45:42 | 01 00:50:00 |  | 01 01:48:29 | 282 | 178 | 70820 | San Jose | True | 28.73 | 6 | 4.31 | 0
01 00:45:49 | 01 01:08:41 |  | 01 [NAME] | 66 | 87 | 51889 | Palo Alto | True | 90.5 | 6 | 7.77 | 0
01 00:46:06 | 01 [NAME] | 01 01:20:05 | 01 01:42:07 | 320 | 8 | 32 | Palo Alto | True | 40.8 | 0 | 6.12 | 0
01 00:47:14 | 01 00:50:42 | 01 01:04:59 | 01 01:17:38 | 36 | 139 | 38941 | San Jose | True | 27.21 | 0 | 2.92 | 0
01 00:47:35 | 01 01:12:12 | 01 01:16:28 | 01 01:29:14 | 24 | 72 | 212 | Palo Alto | True | 31.56 | 0 | 2 | 0
01 00:47:54 | 01 00:53:47 | 01 01:23:54 | 01 01:47:23 | 166 | 205 | 5191 | Palo Alto | True | 50.32 | 0 | 2.03 | 0
01 00:48:05 | 01 00:51:59 | 01 01:16:19 | 01 01:33:56 | 243 | 154 | 61333 | San Jose | True | 47.22 | 0 | 7.08 | 0
01 00:48:58 | 01 01:15:54 | 01 01:25:05 | 01 01:41:18 | 262 | 59 | 9972 | Palo Alto | True | 34.76 | 0 | 2.64 | 0
01 00:49:20 | 01 01:01:02 | 01 01:03:26 | 01 01:38:55 | 109 | 194 | 75081 | San Jose | True | 62.55 | 6 | 2.6 | 0
01 00:49:51 | 01 00:54:24 | 01 01:08:18 | 01 01:18:41 | 334 | 304 | 55330 | San Jose | True | 26.6 | 0 | 2.66 | 0
01 00:51:14 | 01 01:03:57 |  | 01 01:35:26 | 245 | 90 | 9567 | Mountain View | True | 22.8 | 0 | 1.54 | 0
01 00:52:03 | 01 01:03:46 | 01 01:23:38 | 01 01:40:41 | 101 | 250 | 54965 | Mountain View | True | 33.62 | 0 | 1.68 | 0
01 00:52:37 | 01 01:55:48 | 01 02:08:15 | 01 02:24:13 | 320 | 5 | 75107 | Palo Alto | False | 39.71 | 6 | 1.55 | 6
01 00:53:43 | 01 00:56:43 | 01 01:04:08 | 01 01:30:02 | 34 | 27 | 978 | Palo Alto | True | 53.2 | 0 | 2.17 | 0
01 00:53:56 | 01 00:55:09 | 01 01:17:47 | 01 01:41:53 | 248 | 77 | 2696 | Mountain View | True | 40.64 | 0 | 1.59 | 0
01 00:54:08 | 01 [NAME] |  | 01 01:45:14 | 222 | 83 | 14519 | Palo Alto | True | 24.98 | 0 | 1.25 | 0
01 00:54:25 | 01 01:01:01 |  | 01 02:01:19 | 324 | 86 | 8501 | Palo Alto | True | 18.51 | 0 | 1.15 | 0
01 00:55:53 | 01 00:57:37 |  | 01 01:50:09 | 196 | 41 | 6618 | Mountain View | True | 112.58 | 0 | 4.9 | 0
01 00:56:11 | 01 00:57:27 | 01 01:10:05 | 01 01:43:34 | 84 | 8 | 8000 | Palo Alto | True | 92.25 | 0 | 3.96 | 0
01 00:56:18 | 01 00:59:29 | 01 01:28:11 | 01 01:45:04 | 207 | 30 | 74139 | Mountain View | True | 49.34 | 0 | 2.47 | 0
01 00:56:29 | 01 00:59:39 |  | 01 01:40:33 | 215 | 94 | 60600 | Palo Alto | True | 91.64 | 0 | 2 | 0
01 00:56:40 | 01 01:05:57 | 01 01:30:17 | 01 01:54:30 | 334 | 169 | 14086 | San Jose | True | 22.26 | 0 | 3.34 | 0
01 00:56:49 | 01 01:05:58 | 01 01:36:45 | 01 02:05:35 | 336 | 170 | 58191 | San Jose | True | 23.29 | 0 | 0.79 | 0
01 00:57:39 | 01 00:59:51 | 01 01:27:56 | 01 01:46:08 | 198 | 9 | 75131 | Palo Alto | True | 33.19 | 6 | 2.5 | 0
01 00:58:11 | 01 00:59:59 | 01 01:08:35 | 01 01:41:30 | 276 | 107 | 32484 | Palo Alto | True | 35.31 | 0 | 2.69 | 0
01 00:58:29 | 01 01:03:09 | 01 01:30:33 | 01 01:41:58 | 73 | 36 | 1975 | Mountain View | True | 52.11 | 0 | 2.61 | 0
01 00:58:46 | 01 01:17:18 |  | 01 02:09:55 | 317 | 253 | 61777 | San Jose | True | 38.63 | 0 | 3 | 0
01 00:59:41 | 01 01:01:48 | 01 01:40:42 | 01 02:00:48 | 204 | 266 | 75050 | Mountain View | True | 31.94 | 6 | 0 | 0
01 00:59:52 | 01 01:00:49 | 01 01:18:00 | 01 01:38:56 | 319 | 20 | 2946 | Palo Alto | True | 55.25 | 0 | 4.52 | 0
01 00:59:54 | 01 01:06:34 | 01 01:47:46 | 01 02:14:18 | 308 | 324 | 6623 | Palo Alto | True | 139.02 | 0 | 5.84 | 0
01 01:00:17 | 01 01:21:41 | 01 01:31:50 | 01 01:57:59 | 160 | 140 | 75091 | San Jose | True | 16.88 | 6 | 0.5 | 0
01 01:01:02 | 01 01:01:33 | 01 01:27:00 | 01 01:48:39 | 254 | 41 | 36970 | Palo Alto | True | 79.84 | 79.84 | 7.98 | 0
01 01:01:06 | 01 01:01:30 | 01 01:38:29 | 01 02:03:05 | 64 | 98 | 11576 | Mountain View | True | 25.47 | 0 | 3.82 | 0
01 01:01:42 | 01 01:10:02 | 01 01:44:19 | 01 02:01:14 | 245 | 54 | 75096 | Mountain View | True | 52.22 | 6 | 4.25 | 0
01 01:02:20 | 01 01:05:24 |  | 01 01:57:25 | 325 | 47 | 56808 | Palo Alto | True | 226.18 | 0 | 33.93 | 0
01 01:03:48 | 01 01:55:57 | 01 02:06:23 | 01 02:21:44 | 259 | 5 | 1634 | Palo Alto | False | 93.22 | 0 | 4.01 | 0
01 01:04:14 | 01 01:30:52 | 01 01:53:21 | 01 02:13:55 | 297 | 114 | 2734 | Mountain View | True | 38.46 | 0 | 2.98 | 0