Spreadsheet: 887425d1737656733-require-assistance-for-ev-energy-consumption-kwh-and-time-utilization-charge-sessions-greetingsgoodsir-
Sheet: Charge Point 3

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 10:51:50 | 2024-09-01 12:37:50 | 2024-09-01 10:51:50 | 2024-09-01 12:37:50 | 6.165 | 106 | 106 | charge point 3 |  |  |  |  |  |  | charging start time = | charging started
2024-09-01 13:39:33 | 2024-09-01 14:24:47 | 2024-09-01 13:39:33 | 2024-09-01 14:24:47 | 2.611 | 46 | 46 | charge point 3 |  |  |  |  |  |  | charging end time = | charging stopped
2024-09-01 16:08:37 | 2024-09-01 19:56:13 | 2024-09-01 16:08:37 | 2024-09-01 19:56:13 | 12.948 | 228 | 228 | charge point 3 |  |  |  |  |  |  | session start time = | session started (plugged in)
2024-09-06 18:30:30 | 2024-09-06 22:46:19 | 2024-09-06 18:30:30 | 2024-09-07 08:00:16 | 10.919 | 810 | 256 | charge point 3 |  |  |  |  |  |  | session end time = | session completed (plugged out)
2024-09-07 08:54:00 | 2024-09-07 08:59:53 | 2024-09-07 08:54:00 | 2024-09-07 08:59:53 | 0.325 | 6 | 6 | charge point 3 |  |  |  |  |  |  | consumption (kWh) = | energy consumption
2024-09-07 10:53:22 | 2024-09-07 14:16:19 | 2024-09-07 10:53:22 | 2024-09-07 14:30:53 | 11.27 | 218 | 203 | charge point 3 |  |  |  |  |  |  | session duration = | total plug in duration in minutes
2024-09-07 16:57:51 | 2024-09-07 18:52:41 | 2024-09-07 16:57:51 | 2024-09-07 18:52:41 | 0 | 115 | 115 | charge point 3 |  |  |  |  |  |  | charging duration = | total charge duration in minutes
2024-09-08 15:30:11 | 2024-09-08 19:39:03 | 2024-09-08 15:30:11 | 2024-09-08 19:39:03 | 14.159 | 249 | 249 | charge point 3 |  |  |  |  |  |  | charge point = | charging point
2024-09-08 20:55:11 | 2024-09-09 03:51:20 | 2024-09-08 20:55:11 | 2024-09-09 08:13:53 | 24.667 | 679 | 417 | charge point 3
2024-09-09 19:02:10 | 2024-09-10 04:13:50 | 2024-09-09 19:02:10 | 2024-09-10 04:13:50 | 31.141 | 552 | 552 | charge point 3
2024-09-10 08:18:33 | 2024-09-10 20:59:13 | 2024-09-10 08:18:33 | 2024-09-10 20:59:13 | 39.704 | 761 | 761 | charge point 3
2024-09-10 22:13:52 | 2024-09-11 07:36:37 | 2024-09-10 22:13:52 | 2024-09-11 07:36:37 | 25.876 | 563 | 563 | charge point 3
2024-09-11 19:18:40 | 2024-09-11 22:16:21 | 2024-09-11 19:18:40 | 2024-09-12 07:06:52 | 10.286 | 709 | 178 | charge point 3
2024-09-12 12:57:52 | 2024-09-12 13:31:21 | 2024-09-12 12:57:52 | 2024-09-12 18:12:54 | 1.422 | 316 | 34 | charge point 3
2024-09-12 18:20:01 | 2024-09-12 19:33:52 | 2024-09-12 18:20:01 | 2024-09-12 19:33:52 | 4.142 | 74 | 74 | charge point 3
2024-09-12 19:36:00 | 2024-09-13 01:26:21 | 2024-09-12 19:36:00 | 2024-09-13 07:00:29 | 15.156 | 685 | 351 | charge point 3
2024-09-13 18:26:29 | 2024-09-14 05:36:22 | 2024-09-13 18:26:29 | 2024-09-14 05:51:59 | 38.272 | 686 | 670 | charge point 3
2024-09-14 07:27:56 | 2024-09-14 09:26:11 | 2024-09-14 07:27:56 | 2024-09-14 09:26:11 | 6.755 | 119 | 119 | charge point 3
2024-09-14 12:36:24 | 2024-09-14 18:33:11 | 2024-09-14 12:35:57 | 2024-09-14 18:33:11 | 10.498 | 358 | 357 | charge point 3
2024-09-15 15:57:54 | 2024-09-15 20:32:38 | 2024-09-15 15:57:54 | 2024-09-15 20:32:38 | 15.538 | 275 | 275 | charge point 3
2024-09-15 21:40:39 | 2024-09-16 00:56:25 | 2024-09-15 21:40:39 | 2024-09-16 02:48:44 | 8.738 | 309 | 196 | charge point 3
2024-09-16 15:36:14 | 2024-09-16 19:41:33 | 2024-09-16 15:36:14 | 2024-09-16 19:41:33 | 0.031 | 246 | 246 | charge point 3
2024-09-16 20:18:28 | 2024-09-16 20:47:53 | 2024-09-16 20:18:28 | 2024-09-16 20:47:53 | 1.658 | 30 | 30 | charge point 3
2024-09-16 21:00:31 | 2024-09-17 07:38:29 | 2024-09-16 21:00:31 | 2024-09-17 07:38:29 | 35.863 | 638 | 638 | charge point 3
2024-09-17 08:34:24 | 2024-09-17 08:51:25 | 2024-09-17 08:34:24 | 2024-09-17 20:36:12 | 5.279 | 722 | 18 | charge point 3
2024-09-18 05:51:25 | 2024-09-18 08:25:56 | 2024-09-17 20:45:47 | 2024-09-18 08:25:56 | 8.966 | 701 | 155 | charge point 3
2024-09-18 14:52:02 | 2024-09-18 15:11:25 | 2024-09-18 14:52:02 | 2024-09-19 03:17:24 | 4.679 | 746 | 20 | charge point 3
2024-09-19 18:10:18 | 2024-09-20 04:41:25 | 2024-09-19 18:10:18 | 2024-09-20 08:31:00 | 36.487 | 861 | 632 | charge point 3
2024-09-20 09:12:33 | 2024-09-20 13:01:32 | 2024-09-20 09:12:33 | 2024-09-20 13:01:32 | 13.153 | 229 | 229 | charge point 3
2024-09-20 13:53:01 | 2024-09-20 16:34:43 | 2024-09-20 13:53:01 | 2024-09-20 16:34:43 | 9.111 | 162 | 162 | charge point 3
2024-09-20 18:40:01 | 2024-09-21 08:26:50 | 2024-09-20 18:40:01 | 2024-09-21 08:26:50 | 47.088 | 827 | 827 | charge point 3
2024-09-22 12:26:32 | 2024-09-22 15:22:50 | 2024-09-22 12:26:32 | 2024-09-22 15:22:50 | 10.388 | 177 | 177 | charge point 3
2024-09-22 20:08:42 | 2024-09-22 22:11:26 | 2024-09-22 20:08:42 | 2024-09-22 22:21:05 | 6.501 | 133 | 123 | charge point 3
2024-09-23 05:07:19 | 2024-09-23 06:16:26 | 2024-09-23 05:07:19 | 2024-09-23 06:23:38 | 3.69 | 77 | 70 | charge point 3
2024-09-23 16:04:54 | 2024-09-24 07:11:26 | 2024-09-23 16:04:54 | 2024-09-24 07:26:55 | 46.776 | 923 | 907 | charge point 3
2024-09-25 17:37:09 | 2024-09-26 05:46:26 | 2024-09-25 17:37:09 | 2024-09-26 08:17:00 | 41.831 | 880 | 730 | charge point 3
2024-09-26 14:45:29 | 2024-09-26 20:47:26 | 2024-09-26 14:45:29 | 2024-09-26 20:47:26 | 20.487 | 362 | 362 | charge point 3
2024-09-27 17:57:18 | 2024-09-28 04:46:26 | 2024-09-27 17:57:18 | 2024-09-28 08:36:19 | 37.497 | 880 | 650 | charge point 3
2024-09-28 13:45:54 | 2024-09-28 20:06:26 | 2024-09-28 13:45:54 | 2024-09-28 22:08:12 | 17.132 | 503 | 381 | charge point 3
2024-09-29 05:13:29 | 2024-09-29 08:31:02 | 2024-09-29 05:13:29 | 2024-09-29 08:31:02 | 10.789 | 198 | 198 | charge point 3
2024-09-29 10:50:36 | 2024-09-29 12:31:26 | 2024-09-29 10:50:36 | 2024-09-29 16:06:59 | 4.385 | 317 | 101 | charge point 3
2024-09-29 20:32:17 | 2024-09-29 21:04:34 | 2024-09-29 20:32:17 | 2024-09-29 21:04:34 | 1.802 | 33 | 33 | charge point 3
2024-09-29 21:53:59 | 2024-09-30 04:56:26 | 2024-09-29 21:53:59 | 2024-09-30 06:24:19 | 23.146 | 511 | 423 | charge point 3