Spreadsheet: 732790d1621243964-date-and-time-function-book7
Sheet: Sheet1

 | Start Time | [NAME] | Start Location |  |  |  |  | End Time | End Odo | End Location |  |  |  |  |  | Km
 | 2021-04-20 00:00:00
 | 2021-04-20 13:09:17 | 199842.9 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-04-20 13:25:37 | 199852.5 | Johannes Ramokhoase Street (N4), Pretoria, Gauteng, South Africa |  |  |  |  |  | 9.60000000000582
 | 2021-04-20 16:09:43 | 199852.5 | Johannes Ramokhoase Street (N4), Pretoria, Gauteng, South Africa |  |  |  |  | 2021-04-20 16:28:34 | 199861.7 | Church Avenue, LYNNWOOD, Pretoria, Gauteng, South Africa |  |  |  |  |  | 9.200000000011642
 | 2021-04-20 16:32:02 | 199861.7 | Church Avenue, LYNNWOOD, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-04-20 16:35:27 | 199863.4 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 1.699999999982538
 | 2021-05-06 00:00:00
 | 2021-05-06 09:22:10 | 199863.4 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 09:24:48 | 199864.5 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 1.100000000005821
 | 2021-05-06 09:34:05 | 199864.5 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 10:05:11 | 199907.6 | [NAME], KEMPTON PARK, Gauteng, South Africa |  |  |  |  |  | 43.10000000000582
 | 2021-05-06 10:31:59 | 199907.6 | [NAME], KEMPTON PARK, Gauteng, South Africa |  |  |  |  | 2021-05-06 10:36:00 | 199908.1 | [NAME], KEMPTON PARK, Gauteng, South Africa |  |  |  |  |  | 0.5
 | 2021-05-06 11:15:02 | 199908.1 | [NAME], KEMPTON PARK, Gauteng, South Africa |  |  |  |  | 2021-05-06 13:18:47 | 200014.7 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 106.6000000000058
 | 2021-05-06 15:24:44 | 200014.7 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 15:32:16 | 200017.3 | Duxbury Road (M30), HILLCREST, Pretoria, Gauteng, South Africa |  |  |  |  |  | 2.599999999976717
 | 2021-05-06 15:44:46 | 200017.3 | Duxbury Road (M30), HILLCREST, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 15:46:18 | 200017.5 | Brooklyn Road (M30), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 0.2000000000116415
 | 2021-05-06 15:57:04 | 200017.5 | Brooklyn Road (M30), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 16:04:55 | 200020.3 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 2.799999999988358
 | 2021-05-06 17:18:52 | 200020.3 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 17:28:20 | 200023.1 | Bariton Street, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 2.800000000017462
 | 2021-05-06 17:29:19 | 200023.1 | Brooklyn Road (M30), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 17:35:06 | 200025.8 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 2.699999999982538
 | 2021-05-06 19:08:33 | 200025.8 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 19:16:06 | 200029.8 | Garsfontein Road (M30), [NAME], Pretoria, Gauteng, South Africa |  |  |  |  |  | 4
 | 2021-05-06 19:26:04 | 200029.8 | Garsfontein Road (M30), [NAME], Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 19:31:38 | 200033.1 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 3.300000000017462
 | 2021-05-06 20:02:35 | 200033.1 | Atterbury Road (M11), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-06 20:05:38 | 200034.5 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 1.399999999994179
 | 2021-05-07 00:00:00
 | 2021-05-07 08:27:32 | 200034.5 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 08:47:46 | 200053.7 | Muirfield Crescent, SILVER LAKES, Pretoria, Gauteng, South Africa |  |  |  |  |  | 19.20000000001164
 | 2021-05-07 09:09:41 | 200053.7 | Muirfield Crescent, SILVER LAKES, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 09:23:28 | 200059.6 | [NAME], NELLMAPIUS, Pretoria, Gauteng, South Africa |  |  |  |  |  | 5.899999999994179
 | 2021-05-07 09:56:03 | 200059.6 | [NAME], NELLMAPIUS, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 10:17:34 | 200079.9 | Fehrsen Street, BROOKLYN, Pretoria, Gauteng, South Africa |  |  |  |  |  | 20.29999999998836
 | 2021-05-07 11:14:37 | 200079.9 | Fehrsen Street, BROOKLYN, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 11:23:37 | 200084 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 4.100000000005821
 | 2021-05-07 11:27:56 | 200084 | 22ND STREET, MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 11:31:20 | 200086.3 | Lynnwood Road (M6), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  |  | 2.299999999988358
 | 2021-05-07 11:33:44 | 200086.3 | Lynnwood Road (M6), MENLO PARK, Pretoria, Gauteng, South Africa |  |  |  |  | 2021-05-07 12:21:58 | 200156.6 | [NAME], Krugersdorp, Gauteng, South Africa |  |  |  |  |  | 70.30000000001746