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

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 14:31:41 | 2024-09-01 20:33:36 | 2024-09-01 14:31:41 | 2024-09-01 20:33:36 | 20.988 | 362 | 362 | charge point 2 |  |  |  |  |  |  |  | charging start time = | charging started
2024-09-02 00:22:34 | 2024-09-02 04:29:21 | 2024-09-02 00:22:34 | 2024-09-02 04:29:21 | 14.674 | 247 | 247 | charge point 2 |  |  |  |  |  |  |  | charging end time = | charging stopped
2024-09-02 15:51:29 | 2024-09-02 16:21:19 | 2024-09-02 15:51:29 | 2024-09-02 16:21:19 | 1.757 | 30 | 30 | charge point 2 |  |  |  |  |  |  |  | session start time = | session started (plugged in)
2024-09-03 17:56:02 | 2024-09-03 22:39:37 | 2024-09-03 17:56:02 | 2024-09-03 22:39:37 | 15.989 | 284 | 284 | charge point 2 |  |  |  |  |  |  |  | session end time = | session completed (plugged out)
2024-09-04 00:41:41 | 2024-09-04 08:43:57 | 2024-09-04 00:41:41 | 2024-09-04 08:43:57 | 27.689 | 483 | 483 | charge point 2 |  |  |  |  |  |  |  | consumption (kWh) = | energy consumption
2024-09-04 09:05:32 | 2024-09-04 16:59:23 | 2024-09-04 09:05:07 | 2024-09-04 16:59:23 | 27.123 | 475 | 474 | charge point 2 |  |  |  |  |  |  |  | session duration = | total plug in duration in minutes
2024-09-04 17:28:02 | 2024-09-04 23:05:16 | 2024-09-04 17:28:02 | 2024-09-04 23:05:16 | 18.714 | 338 | 338 | charge point 2 |  |  |  |  |  |  |  | charging duration = | total charge duration in minutes
2024-09-05 12:40:33 | 2024-09-05 15:56:00 | 2024-09-05 12:40:11 | 2024-09-05 15:56:00 | 10.886 | 196 | 196 | charge point 2 |  |  |  |  |  |  |  | charge point = | charging point
2024-09-05 16:41:52 | 2024-09-05 18:05:33 | 2024-09-05 16:41:52 | 2024-09-06 10:48:47 | 11.338 | 1087 | 84 | charge point 2
2024-09-06 21:31:46 | 2024-09-07 04:05:33 | 2024-09-06 21:31:46 | 2024-09-07 08:24:54 | 20.478 | 654 | 394 | charge point 2
2024-09-07 15:34:07 | 2024-09-07 16:28:02 | 2024-09-07 15:34:07 | 2024-09-07 16:28:02 | 3.026 | 54 | 54 | charge point 2
2024-09-09 10:39:03 | 2024-09-09 15:13:06 | 2024-09-09 10:39:03 | 2024-09-09 15:13:06 | 15.627 | 275 | 275 | charge point 2
2024-09-09 16:07:58 | 2024-09-09 17:05:33 | 2024-09-09 16:07:58 | 2024-09-09 17:09:27 | 2.814 | 62 | 58 | charge point 2
2024-09-09 18:22:08 | 2024-09-09 19:06:58 | 2024-09-09 18:22:08 | 2024-09-09 19:06:58 | 2.604 | 45 | 45 | charge point 2
2024-09-09 21:26:16 | 2024-09-10 01:36:06 | 2024-09-09 21:26:16 | 2024-09-10 01:36:06 | 13.855 | 250 | 250 | charge point 2
2024-09-10 12:04:39 | 2024-09-10 23:13:09 | 2024-09-10 12:04:39 | 2024-09-10 23:13:09 | 37.963 | 669 | 669 | charge point 2
2024-09-12 13:59:25 | 2024-09-12 14:40:33 | 2024-09-12 13:59:25 | 2024-09-12 16:33:17 | 1.913 | 154 | 42 | charge point 2
2024-09-12 19:23:45 | 2024-09-12 19:50:33 | 2024-09-12 19:23:45 | 2024-09-12 20:15:07 | 1.582 | 52 | 27 | charge point 2
2024-09-12 20:30:39 | 2024-09-13 06:45:33 | 2024-09-12 20:30:39 | 2024-09-13 07:19:42 | 35.112 | 650 | 615 | charge point 2
2024-09-13 20:11:28 | 2024-09-14 01:15:33 | 2024-09-13 20:11:28 | 2024-09-14 02:41:03 | 17.298 | 390 | 305 | charge point 2
2024-09-14 13:33:38 | 2024-09-14 14:25:17 | 2024-09-14 13:33:38 | 2024-09-14 14:25:17 | 2.742 | 52 | 52 | charge point 2
2024-09-14 14:32:01 | 2024-09-15 04:00:34 | 2024-09-14 14:32:01 | 2024-09-15 09:32:53 | 45.936 | 1141 | 809 | charge point 2
2024-09-15 13:11:06 | 2024-09-15 13:30:34 | 2024-09-15 13:11:06 | 2024-09-15 14:56:43 | 1.347 | 106 | 20 | charge point 2
2024-09-15 22:07:37 | 2024-09-16 02:45:34 | 2024-09-15 22:07:37 | 2024-09-16 02:48:41 | 14.534 | 282 | 278 | charge point 2
2024-09-16 20:18:28 | 2024-09-16 22:30:34 | 2024-09-16 20:18:28 | 2024-09-17 06:15:53 | 10.198 | 598 | 133 | charge point 2
2024-09-17 12:09:41 | 2024-09-17 12:35:34 | 2024-09-17 12:09:41 | 2024-09-17 17:18:17 | 3.179 | 309 | 26 | charge point 2
2024-09-17 18:08:55 | 2024-09-18 07:37:35 | 2024-09-17 18:08:55 | 2024-09-18 07:37:35 | 46.807 | 809 | 809 | charge point 2
2024-09-18 21:38:10 | 2024-09-19 05:25:34 | 2024-09-18 21:38:10 | 2024-09-19 07:58:36 | 22.463 | 621 | 468 | charge point 2
2024-09-19 16:09:20 | 2024-09-19 16:26:30 | 2024-09-19 16:09:20 | 2024-09-19 16:26:30 | 0.988 | 18 | 18 | charge point 2
2024-09-19 19:10:09 | 2024-09-19 22:35:34 | 2024-09-19 19:10:09 | 2024-09-20 06:48:25 | 11.221 | 699 | 206 | charge point 2
2024-09-20 09:19:31 | 2024-09-20 12:01:55 | 2024-09-20 09:19:31 | 2024-09-20 12:01:55 | 9.263 | 163 | 163 | charge point 2
2024-09-20 18:17:39 | 2024-09-21 05:25:34 | 2024-09-20 18:17:39 | 2024-09-21 06:31:21 | 38.863 | 734 | 668 | charge point 2
2024-09-21 11:23:58 | 2024-09-21 11:50:06 | 2024-09-21 11:23:58 | 2024-09-21 11:50:06 | 1.504 | 27 | 27 | charge point 2
2024-09-21 15:30:34 | 2024-09-21 15:52:17 | 2024-09-21 15:30:12 | 2024-09-21 15:52:17 | 1.295 | 23 | 22 | charge point 2
2024-09-21 17:26:19 | 2024-09-22 05:20:34 | 2024-09-21 17:26:19 | 2024-09-22 12:44:31 | 41.406 | 1159 | 715 | charge point 2
2024-09-22 14:29:57 | 2024-09-22 16:36:26 | 2024-09-22 14:29:57 | 2024-09-22 16:36:26 | 7.145 | 127 | 127 | charge point 2
2024-09-22 20:08:42 | 2024-09-22 20:25:52 | 2024-09-22 20:08:42 | 2024-09-22 20:25:52 | 0.979 | 18 | 18 | charge point 2
2024-09-23 05:07:19 | 2024-09-23 05:57:57 | 2024-09-23 05:07:19 | 2024-09-23 05:57:57 | 2.968 | 51 | 51 | charge point 2
2024-09-23 20:35:54 | 2024-09-23 21:10:34 | 2024-09-23 20:35:54 | 2024-09-24 01:50:23 | 1.94 | 315 | 35 | charge point 2
2024-09-25 15:08:17 | 2024-09-25 17:35:35 | 2024-09-25 15:08:17 | 2024-09-25 20:03:10 | 8.524 | 295 | 148 | charge point 2
2024-09-25 22:55:35 | 2024-09-26 08:04:07 | 2024-09-25 22:55:33 | 2024-09-26 08:04:07 | 32.16 | 549 | 549 | charge point 2
2024-09-26 09:54:32 | 2024-09-26 20:07:17 | 2024-09-26 09:54:32 | 2024-09-26 20:07:17 | 32.107 | 613 | 613 | charge point 2
2024-09-27 22:23:49 | 2024-09-28 02:20:35 | 2024-09-27 22:23:49 | 2024-09-28 07:04:21 | 14.273 | 521 | 237 | charge point 2
2024-09-28 16:33:04 | 2024-09-28 20:40:35 | 2024-09-28 16:33:04 | 2024-09-28 21:09:14 | 14.145 | 277 | 248 | charge point 2
2024-09-28 21:53:19 | 2024-09-29 02:05:35 | 2024-09-28 21:53:19 | 2024-09-29 07:55:38 | 15.796 | 603 | 253 | charge point 2
2024-09-29 15:37:25 | 2024-09-29 19:59:09 | 2024-09-29 15:37:25 | 2024-09-29 19:59:09 | 14.679 | 262 | 262 | charge point 2
2024-09-29 21:53:58 | 2024-09-30 00:00:35 | 2024-09-29 21:53:58 | 2024-09-30 10:35:09 | 6.692 | 762 | 127 | charge point 2
2024-09-30 17:39:20 | 2024-09-30 19:10:05 | 2024-09-30 17:39:20 | 2024-09-30 19:10:05 | 5.157 | 91 | 91 | charge point 2