Spreadsheet: 147797d1332967931-get-data-between-two-datetime-cells-excel2
Sheet: Sheet1

DATETIME | TOTAL FLOWS | SUCCESSFULFLOWS |  | Changed Date Format | Flows Per 15 mins | Flows per Hour |  |  |  |  |  |  |  |  | Interval Upper Boundary | Cumulative Total | Interval Amount
19032012 00:06 | 212 | 212 |  | 2012-03-19 00:06:00 | 0 | 10 |  |  | #N/A |  |  |  |  |  | 2012-03-19 00:06:00
19032012 00:21 | 212 | 212 |  | 2012-03-19 00:21:00 | 6 |  |  |  |  |  |  |  |  |  | 2012-03-19 01:06:00 | 10 | 10
19032012 00:36 | 218 | 218 |  | 2012-03-19 00:36:00 | 0 |  |  |  |  |  |  |  |  |  | 2012-03-19 02:06:00 | 48 | 38
19032012 00:51 | 218 | 218 |  | 2012-03-19 00:51:00 | 4 |  |  |  |  |  |  |  |  |  | 2012-03-19 03:06:00 | 78 | 30
19032012 01:06 | 222 | 222 |  | 2012-03-19 01:06:00 | 4 | 38 |  |  | This List goes on and is fetched from a database, Here the flow at 19032012 03:51 is missing, so the entire fomula per hour goes wrong and is continued down. |  |  |  |  |  | 2012-03-19 04:06:00 | 101 | 23
19032012 01:21 | 226 | 226 |  | 2012-03-19 01:21:00 | 16 |  |  |  |  |  |  |  |  |  | 2012-03-19 05:06:00 | 135 | 34
19032012 01:36 | 242 | 242 |  | 2012-03-19 01:36:00 | 11 |  |  |  |  |  |  |  |  |  | 2012-03-19 06:06:00 | 165 | 30
19032012 01:51 | 253 | 253 |  | 2012-03-19 01:51:00 | 7 |  |  |  |  |  |  |  |  |  | 2012-03-19 07:06:00 | 200 | 35
19032012 02:06 | 260 | 260 |  | 2012-03-19 02:06:00 | 7 | 30 |  |  |  |  |  |  |  |  | 2012-03-19 08:06:00 | -212 | -412
19032012 02:21 | 267 | 267 |  | 2012-03-19 02:21:00 | 9 |  |  |  |  |  |  |  |  |  | 2012-03-19 09:06:00 | -212 | 0
19032012 02:36 | 276 | 276 |  | 2012-03-19 02:36:00 | 7 |  |  |  |  |  |  |  |  |  | 2012-03-19 10:06:00 | -212 | 0
19032012 02:51 | 283 | 283 |  | 2012-03-19 02:51:00 | 7 |  |  |  |  |  |  |  |  |  | 2012-03-19 11:06:00 | -212 | 0
19032012 03:06 | 290 | 290 |  | 2012-03-19 03:06:00 | 2 | 33 |  |  |  |  |  |  |  |  | 2012-03-19 12:06:00 | -212 | 0
19032012 03:21 | 292 | 292 |  | 2012-03-19 03:21:00 | 8 |  |  |  |  |  |  |  |  |  | 2012-03-19 13:06:00 | -212 | 0
19032012 03:36 | 300 | 300 |  | 2012-03-19 03:36:00 | 13 |  |  |  |  |  |  |  |  |  | 2012-03-19 14:06:00 | -212 | 0
19032012 04:06 | 313 | 313 |  | 2012-03-19 04:06:00 | 10 |  |  |  |  |  |  |  |  |  | 2012-03-19 15:06:00 | -212 | 0
19032012 04:21 | 323 | 323 |  | 2012-03-19 04:21:00 | 7 | 31 |  |  |  |  |  |  |  |  | 2012-03-19 16:06:00 | -212 | 0
19032012 04:36 | 330 | 330 |  | 2012-03-19 04:36:00 | 11 |  |  |  |  |  |  |  |  |  | 2012-03-19 17:06:00 | -212 | 0
19032012 04:51 | 341 | 341 |  | 2012-03-19 04:51:00 | 6 |  |  |  |  |  |  |  |  |  | 2012-03-19 18:06:00 | -212 | 0
19032012 05:06 | 347 | 347 |  | 2012-03-19 05:06:00 | 7 |  |  |  |  |  |  |  |  |  | 2012-03-19 19:06:00 | -212 | 0
19032012 05:21 | 354 | 354 |  | 2012-03-19 05:21:00 | 10 | 32 |  |  |  |  |  |  |  |  | 2012-03-19 20:06:00 | -212 | 0
19032012 05:36 | 364 | 364 |  | 2012-03-19 05:36:00 | 9 |  |  |  |  |  |  |  |  |  | 2012-03-19 21:06:00 | -212 | 0
19032012 05:51 | 373 | 373 |  | 2012-03-19 05:51:00 | 4 |  |  |  |  |  |  |  |  |  | 2012-03-19 22:06:00 | -212 | 0
19032012 06:06 | 377 | 377 |  | 2012-03-19 06:06:00 | 9 |  |  |  |  |  |  |  |  |  | 2012-03-19 23:06:00 | -212 | 0
19032012 06:21 | 386 | 386 |  | 2012-03-19 06:21:00 | 13 | 29 |  |  |  |  |  |  |  |  | 2012-03-20 00:06:00 | -212 | 0
19032012 06:36 | 399 | 399 |  | 2012-03-19 06:36:00 | 9
19032012 06:51 | 408 | 408 |  | 2012-03-19 06:51:00 | 4
19032012 07:06 | 412 | 412 |  | 2012-03-19 07:06:00 | 3
19032012 07:21 | 415 | 415 |  | 2012-03-19 07:21:00 | 2 | -415
19032012 07:36 | 417 | 417 |  | 2012-03-19 07:36:00 | -417