Spreadsheet: 847168d1698227336-extract-rolling-total-calculate-usage-copy-into-table-example
Sheet: Sheet1

Extracted Date/Time | Date | Time | Time Rounded | Day/Night | Extracted Rolling Total
2023-03-01 07:28:43.443000 |  |  |  |  | 18251
2023-03-01 07:28:53.430000 |  |  |  |  | 18252
2023-03-01 07:29:03.370000 |  |  |  |  | 18253
2023-03-01 07:29:13.323000 |  |  |  |  | 18254
2023-03-01 07:29:18.560000 |  |  |  |  | 18255
2023-03-01 07:29:23.796000 |  |  |  |  | 18256
2023-03-01 07:29:29.030000 |  |  |  |  | 18257
2023-03-01 07:29:34.296000 |  |  |  |  | 18258
2023-03-01 07:29:39.250000 |  |  |  |  | 18375
2023-03-01 08:59:22.033000 |  |  |  |  | 18377
2023-03-01 09:59:24.576000 |  |  |  |  | 18378
2023-03-01 10:59:27.056000 |  |  |  |  | 18379
2023-03-01 11:59:29.593000 |  |  |  |  | 18380
2023-03-01 12:59:31.056000 |  |  |  |  | 18381
2023-03-01 13:59:33.503000 |  |  |  |  | 18382
2023-03-01 14:59:36.030000 |  |  |  |  | 18383
2023-03-01 15:59:38.313000 |  |  |  |  | 18384
2023-03-01 16:59:40.853000 |  |  |  |  | 18385
2023-03-01 17:59:43.286000 |  |  |  |  | 18386
2023-03-01 18:59:45.830000 |  |  |  |  | 18387
2023-03-01 19:59:48.333000 |  |  |  |  | 18388
2023-03-01 20:59:50.836000 |  |  |  |  | 18389
2023-03-01 21:59:53.366000 |  |  |  |  | 18390
2023-03-01 22:59:55.873000 |  |  |  |  | 18391
2023-03-01 23:58:22.460000 |  |  |  |  | 18392
2023-03-01 23:59:58.406000 |  |  |  |  | 18392
2023-03-02 01:00:00.466000 |  |  |  |  | 18393
2023-03-02 02:00:02.920000 |  |  |  |  | 18394
2023-03-02 03:00:06.133000 |  |  |  |  | 18395
2023-03-02 04:00:09.126000 |  |  |  |  | 18396
2023-03-02 05:00:11.973000 |  |  |  |  | 18397
2023-03-02 06:00:14.230000 |  |  |  |  | 18398
2023-03-02 07:00:16.816000 |  |  |  |  | 18399
2023-03-02 08:00:19.370000 |  |  |  |  | 18400
2023-03-02 09:59:19.950000 |  |  |  |  | 18402
2023-03-02 10:59:22.426000 |  |  |  |  | 18403
2023-03-02 11:59:24.980000 |  |  |  |  | 18404
2023-03-02 12:59:26.293000 |  |  |  |  | 18405
2023-03-02 13:59:28.880000 |  |  |  |  | 18406
2023-03-02 14:59:31.423000 |  |  |  |  | 18407
2023-03-02 15:59:33.896000 |  |  |  |  | 18408
2023-03-02 16:59:36.466000 |  |  |  |  | 18409
2023-03-02 17:59:38.906000 |  |  |  |  | 18410
2023-03-02 18:59:41.406000 |  |  |  |  | 18411
2023-03-02 19:59:43.953000 |  |  |  |  | 18412
2023-03-02 20:59:46.423000 |  |  |  |  | 18413
2023-03-02 21:59:48.933000 |  |  |  |  | 18414
2023-03-02 22:59:51.483000 |  |  |  |  | 18415
2023-03-02 23:58:17.966000 |  |  |  |  | 18416
2023-03-02 23:59:54.010000 |  |  |  |  | 18416
2023-03-03 00:59:55.983000 |  |  |  |  | 18417
2023-03-03 01:59:58.503000 |  |  |  |  | 18418
2023-03-03 03:00:00.943000 |  |  |  |  | 18419
2023-03-03 04:00:03.803000 |  |  |  |  | 18420
2023-03-03 05:00:07.006000 |  |  |  |  | 18421
2023-03-03 06:00:09.693000 |  |  |  |  | 18422
2023-03-03 07:00:12.410000 |  |  |  |  | 18423
2023-03-03 08:00:14.366000 |  |  |  |  | 18424
2023-03-03 09:59:18.303000 |  |  |  |  | 18426
2023-03-03 10:59:20.773000 |  |  |  |  | 18427
2023-03-03 11:59:23.206000 |  |  |  |  | 18428
2023-03-03 12:59:24.590000 |  |  |  |  | 18429
2023-03-03 13:59:27.113000 |  |  |  |  | 18430
2023-03-03 14:59:29.613000 |  |  |  |  | 18431
2023-03-03 15:59:32.056000 |  |  |  |  | 18432
2023-03-03 16:59:34.603000 |  |  |  |  | 18433
2023-03-03 17:59:37.133000 |  |  |  |  | 18434
2023-03-03 18:59:39.596000 |  |  |  |  | 18435
2023-03-03 19:59:42.100000 |  |  |  |  | 18436
2023-03-03 20:59:44.586000 |  |  |  |  | 18437
2023-03-03 21:59:47.110000 |  |  |  |  | 18438
2023-03-03 22:59:49.640000 |  |  |  |  | 18439
2023-03-03 23:58:16.156000 |  |  |  |  | 18440
2023-03-03 23:59:52.193000 |  |  |  |  | 18440
2023-03-04 00:59:54.090000 |  |  |  |  | 18441
2023-03-04 01:59:56.560000 |  |  |  |  | 18442
2023-03-04 02:59:59.043000 |  |  |  |  | 18443
2023-03-04 04:00:01.526000 |  |  |  |  | 18444
2023-03-04 05:00:04.233000 |  |  |  |  | 18445
2023-03-04 06:00:06.920000 |  |  |  |  | 18446