Spreadsheet: 887518d1737742245-require-assistance-for-ev-energy-consumption-kwh-and-time-utilization-charge-sessions-greetingsgoodsir-
Sheet: Charge Point 1

charging start time | charging end time | session start time | session end time | consumption (kWh) | session duration | charging duration | charge point | con./hr. | 1st hr | Last hr | 2nd hr strt | Pen. hr end
2024-09-01 13:39:29 | 2024-09-01 14:15:32 | 2024-09-01 13:39:29 | 2024-09-01 17:24:14 | 3.027 | 225 | 37 | Charge Point 1 |  |  |  |  |  |  | charging start time = | charging started
2024-09-01 20:12:12 | 2024-09-01 21:03:57 | 2024-09-01 20:12:12 | 2024-09-01 21:03:57 | 2.876 | 52 | 52 | Charge Point 1 |  |  |  |  |  |  | charging end time = | charging stopped
2024-09-02 01:15:32 | 2024-09-02 08:37:57 | 2024-09-02 01:15:30 | 2024-09-02 08:37:57 | 25.231 | 443 | 443 | Charge Point 1 |  |  |  |  |  |  | session start time = | session started (plugged in)
2024-09-03 00:11:08 | 2024-09-03 12:23:27 | 2024-09-03 00:11:08 | 2024-09-03 12:23:27 | 38.411 | 733 | 733 | Charge Point 1 |  |  |  |  |  |  | session end time = | session completed (plugged out)
2024-09-03 14:38:00 | 2024-09-03 18:10:14 | 2024-09-03 14:38:00 | 2024-09-03 18:10:14 | 11.947 | 213 | 213 | Charge Point 1 |  |  |  |  |  |  | consumption (kWh) = | energy consumption
2024-09-03 19:05:32 | 2024-09-03 23:30:32 | 2024-09-03 19:05:21 | 2024-09-04 06:49:55 | 14.473 | 705 | 265 | Charge Point 1 |  |  |  |  |  |  | session duration = | total plug in duration in minutes
2024-09-04 10:28:14 | 2024-09-04 13:19:38 | 2024-09-04 10:28:14 | 2024-09-04 13:19:38 | 6.128 | 172 | 172 | Charge Point 1 |  |  |  |  |  |  | charging duration = | total charge duration in minutes
2024-09-04 17:52:14 | 2024-09-05 07:44:22 | 2024-09-04 17:52:14 | 2024-09-05 07:44:22 | 48.332 | 833 | 833 | Charge Point 1 |  |  |  |  |  |  | charge point = | charging point
2024-09-05 14:47:03 | 2024-09-06 04:30:33 | 2024-09-05 14:47:03 | 2024-09-06 05:29:46 | 47.295 | 883 | 824 | Charge Point 1
2024-09-06 14:25:33 | 2024-09-06 20:32:35 | 2024-09-06 14:25:09 | 2024-09-06 20:32:35 | 20.813 | 368 | 368 | Charge Point 1
2024-09-07 00:36:07 | 2024-09-07 03:25:33 | 2024-09-07 00:36:07 | 2024-09-07 07:39:16 | 9.002 | 424 | 170 | Charge Point 1
2024-09-07 12:34:56 | 2024-09-07 15:42:19 | 2024-09-07 12:34:56 | 2024-09-07 15:42:19 | 11.025 | 188 | 188 | Charge Point 1
2024-09-07 16:32:29 | 2024-09-07 20:30:33 | 2024-09-07 16:32:29 | 2024-09-07 22:07:47 | 9.001 | 336 | 239 | Charge Point 1
2024-09-08 01:02:03 | 2024-09-08 06:55:33 | 2024-09-08 01:02:03 | 2024-09-08 10:46:48 | 21.324 | 585 | 354 | Charge Point 1
2024-09-09 06:56:39 | 2024-09-09 12:43:31 | 2024-09-09 06:56:39 | 2024-09-09 12:43:31 | 17.288 | 347 | 347 | Charge Point 1
2024-09-10 00:22:49 | 2024-09-10 03:20:33 | 2024-09-10 00:22:49 | 2024-09-10 06:42:28 | 11.185 | 380 | 178 | Charge Point 1
2024-09-10 22:58:43 | 2024-09-11 08:49:45 | 2024-09-10 22:58:43 | 2024-09-11 08:49:45 | 34.058 | 592 | 592 | Charge Point 1
2024-09-11 16:38:59 | 2024-09-11 17:30:33 | 2024-09-11 16:38:59 | 2024-09-12 01:49:30 | 5.414 | 551 | 52 | Charge Point 1
2024-09-12 18:30:33 | 2024-09-12 19:04:00 | 2024-09-12 18:30:12 | 2024-09-12 19:04:00 | 1.482 | 34 | 34 | Charge Point 1
2024-09-12 22:12:49 | 2024-09-13 08:08:50 | 2024-09-12 22:12:49 | 2024-09-13 08:08:50 | 34.499 | 597 | 597 | Charge Point 1
2024-09-13 20:11:27 | 2024-09-13 22:55:33 | 2024-09-13 20:11:27 | 2024-09-13 22:56:55 | 9.019 | 166 | 165 | Charge Point 1
2024-09-13 23:35:33 | 2024-09-14 09:15:33 | 2024-09-13 23:35:19 | 2024-09-14 10:16:05 | 33.931 | 641 | 580 | Charge Point 1
2024-09-14 21:53:55 | 2024-09-15 05:25:34 | 2024-09-14 21:53:55 | 2024-09-15 10:39:12 | 25.186 | 766 | 452 | Charge Point 1
2024-09-15 16:04:52 | 2024-09-15 17:30:34 | 2024-09-15 16:04:52 | 2024-09-15 17:45:47 | 4.538 | 101 | 86 | Charge Point 1
2024-09-15 21:40:39 | 2024-09-16 01:05:34 | 2024-09-15 21:40:39 | 2024-09-16 02:48:36 | 11.473 | 308 | 205 | Charge Point 1
2024-09-16 16:00:34 | 2024-09-16 16:16:24 | 2024-09-16 16:00:31 | 2024-09-16 16:16:24 | 0.882 | 16 | 16 | Charge Point 1
2024-09-16 17:55:34 | 2024-09-16 18:37:43 | 2024-09-16 17:55:13 | 2024-09-16 18:37:43 | 1.502 | 43 | 43 | Charge Point 1
2024-09-17 16:44:29 | 2024-09-18 01:53:30 | 2024-09-17 16:44:29 | 2024-09-18 01:53:30 | 31.161 | 550 | 550 | Charge Point 1
2024-09-18 18:40:34 | 2024-09-18 20:05:34 | 2024-09-18 18:01:06 | 2024-09-19 10:23:12 | 9.262 | 983 | 85 | Charge Point 1
2024-09-19 18:04:07 | 2024-09-19 21:40:34 | 2024-09-19 18:04:07 | 2024-09-19 22:15:01 | 10.815 | 251 | 217 | Charge Point 1
2024-09-20 16:35:34 | 2024-09-20 16:38:59 | 2024-09-20 16:35:19 | 2024-09-20 16:38:59 | 0.193 | 4 | 4 | Charge Point 1
2024-09-20 22:22:28 | 2024-09-21 21:59:41 | 2024-09-20 22:22:28 | 2024-09-21 21:59:41 | 12.806 | 1418 | 1418 | Charge Point 1
2024-09-22 14:48:18 | 2024-09-22 18:25:34 | 2024-09-22 14:48:18 | 2024-09-22 22:52:47 | 12.613 | 485 | 218 | Charge Point 1
2024-09-23 18:11:07 | 2024-09-24 06:41:15 | 2024-09-23 18:11:07 | 2024-09-24 06:41:15 | 0 | 751 | 751 | Charge Point 1
2024-09-24 16:07:51 | 2024-09-24 20:44:49 | 2024-09-24 16:07:51 | 2024-09-24 20:44:49 | 15.884 | 277 | 277 | Charge Point 1
2024-09-26 19:55:21 | 2024-09-27 07:59:21 | 2024-09-26 19:55:21 | 2024-09-27 07:59:21 | 41.833 | 724 | 724 | Charge Point 1
2024-09-27 19:26:57 | 2024-09-27 19:50:35 | 2024-09-27 19:26:57 | 2024-09-27 22:59:41 | 0.963 | 213 | 24 | Charge Point 1
2024-09-28 00:43:15 | 2024-09-28 08:36:25 | 2024-09-28 00:43:15 | 2024-09-28 08:36:25 | 27.009 | 474 | 474 | Charge Point 1
2024-09-29 05:13:29 | 2024-09-29 06:50:39 | 2024-09-29 05:13:29 | 2024-09-29 06:50:39 | 5.669 | 98 | 98 | Charge Point 1
2024-09-29 17:24:56 | 2024-09-29 19:31:38 | 2024-09-29 17:24:56 | 2024-09-29 19:31:38 | 7.148 | 127 | 127 | Charge Point 1
2024-09-30 17:34:43 | 2024-10-01 04:45:36 | 2024-09-30 17:34:43 | 2024-10-01 07:08:29 | 38.523 | 814 | 671 | Charge Point 1