Spreadsheet: 151930d1335189966-convert-time-series-with-irregular-time-interval-to-a-regular-time-interval-example
Sheet: Blad1

2008-03-06 00:00:00 | 0 |  | 2008-03-06 00:00:00
2008-03-06 13:20:00 | 1 |  | 2008-03-06 00:15:00
2008-03-06 13:35:00 | 1 |  | 2008-03-06 00:30:00
2008-03-06 14:33:00 | 1 |  | 2008-03-06 00:45:00
2008-03-06 16:34:00 | 1 |  | 2008-03-06 01:00:00
2008-03-06 17:49:00 | 1 |  | 2008-03-06 01:15:00
2008-03-07 00:00:00 | 0 |  | 2008-03-06 01:30:00
2008-03-08 00:00:00 | 0 |  | 2008-03-06 01:45:00
2008-03-08 04:20:00 | 1 |  | 2008-03-06 02:00:00
2008-03-09 00:00:00 | 0 |  | 2008-03-06 02:15:00
2008-03-09 12:09:00 | 1 |  | 2008-03-06 02:30:00
2008-03-09 12:44:00 | 1 |  | 2008-03-06 02:45:00
 |  |  | 2008-03-06 03:00:00
 |  |  | 2008-03-06 03:15:00
 |  |  | 2008-03-06 03:30:00
 |  |  | 2008-03-06 03:45:00
 |  |  | 2008-03-06 04:00:00
 |  |  | 2008-03-06 04:15:00
 |  |  | 2008-03-06 04:30:00
 |  |  | 2008-03-06 04:45:00
 |  |  | 2008-03-06 05:00:00
 |  |  | 2008-03-06 05:15:00
 |  |  | 2008-03-06 05:30:00
 |  |  | 2008-03-06 05:45:00
 |  |  | 2008-03-06 06:00:00
 |  |  | 2008-03-06 06:15:00
 |  |  | 2008-03-06 06:30:00
 |  |  | 2008-03-06 06:45:00
 |  |  | 2008-03-06 07:00:00
 |  |  | 2008-03-06 07:15:00
 |  |  | 2008-03-06 07:30:00
 |  |  | 2008-03-06 07:45:00
 |  |  | 2008-03-06 08:00:00
 |  |  | 2008-03-06 08:15:00
 |  |  | 2008-03-06 08:30:00
 |  |  | 2008-03-06 08:45:00
 |  |  | 2008-03-06 09:00:00
 |  |  | 2008-03-06 09:15:00
 |  |  | 2008-03-06 09:30:00
 |  |  | 2008-03-06 09:45:00
 |  |  | 2008-03-06 10:00:00
 |  |  | 2008-03-06 10:15:00
 |  |  | 2008-03-06 10:30:00
 |  |  | 2008-03-06 10:45:00
 |  |  | 2008-03-06 11:00:00
 |  |  | 2008-03-06 11:15:00
 |  |  | 2008-03-06 11:30:00
 |  |  | 2008-03-06 11:45:00
 |  |  | 2008-03-06 12:00:00
 |  |  | 2008-03-06 12:15:00
 |  |  | 2008-03-06 12:30:00
 |  |  | 2008-03-06 12:45:00
 |  |  | 2008-03-06 13:00:00
 |  |  | 2008-03-06 13:15:00
 |  |  | 2008-03-06 13:30:00
 |  |  | 2008-03-06 13:45:00
 |  |  | 2008-03-06 14:00:00
 |  |  | 2008-03-06 14:15:00
 |  |  | 2008-03-06 14:30:00
 |  |  | 2008-03-06 14:45:00
 |  |  | 2008-03-06 15:00:00
 |  |  | 2008-03-06 15:15:00
 |  |  | 2008-03-06 15:30:00
 |  |  | 2008-03-06 15:45:00
 |  |  | 2008-03-06 16:00:00
 |  |  | 2008-03-06 16:15:00
 |  |  | 2008-03-06 16:30:00
 |  |  | 2008-03-06 16:45:00
 |  |  | 2008-03-06 17:00:00
 |  |  | 2008-03-06 17:15:00
 |  |  | 2008-03-06 17:30:00
 |  |  | 2008-03-06 17:45:00
 |  |  | 2008-03-06 18:00:00
 |  |  | 2008-03-06 18:15:00
 |  |  | 2008-03-06 18:30:00
 |  |  | 2008-03-06 18:45:00
 |  |  | 2008-03-06 19:00:00
 |  |  | 2008-03-06 19:15:00
 |  |  | 2008-03-06 19:30:00
 |  |  | 2008-03-06 19:45:00
 |  |  | 2008-03-06 20:00:00
 |  |  | 2008-03-06 20:15:00
 |  |  | 2008-03-06 20:30:00
 |  |  | 2008-03-06 20:45:00
 |  |  | 2008-03-06 21:00:00
 |  |  | 2008-03-06 21:15:00
 |  |  | 2008-03-06 21:30:00
 |  |  | 2008-03-06 21:45:00
 |  |  | 2008-03-06 22:00:00
 |  |  | 2008-03-06 22:15:00
 |  |  | 2008-03-06 22:30:00
 |  |  | 2008-03-06 22:45:00
 |  |  | 2008-03-06 23:00:00
 |  |  | 2008-03-06 23:15:00
 |  |  | 2008-03-06 23:30:00
 |  |  | 2008-03-06 23:45:00
 |  |  | 2008-03-07 00:00:00
 |  |  | 2008-03-07 00:15:00
 |  |  | 2008-03-07 00:30:00
 |  |  | 2008-03-07 00:45:00
 |  |  | 2008-03-07 00:59:59
 |  |  | 2008-03-07 01:14:59
 |  |  | 2008-03-07 01:29:59
 |  |  | 2008-03-07 01:44:59
 |  |  | 2008-03-07 01:59:59
 |  |  | 2008-03-07 02:14:59
 |  |  | 2008-03-07 02:29:59
 |  |  | 2008-03-07 02:44:59
 |  |  | 2008-03-07 02:59:59
 |  |  | 2008-03-07 03:14:59
 |  |  | 2008-03-07 03:29:59
 |  |  | 2008-03-07 03:44:59
 |  |  | 2008-03-07 03:59:59
 |  |  | 2008-03-07 04:14:59
 |  |  | 2008-03-07 04:29:59
 |  |  | 2008-03-07 04:44:59
 |  |  | 2008-03-07 04:59:59
 |  |  | 2008-03-07 05:14:59
 |  |  | 2008-03-07 05:29:59
 |  |  | 2008-03-07 05:44:59
 |  |  | 2008-03-07 05:59:59
 |  |  | 2008-03-07 06:14:59
 |  |  | 2008-03-07 06:29:59
 |  |  | 2008-03-07 06:44:59
 |  |  | 2008-03-07 06:59:59
 |  |  | 2008-03-07 07:14:59
 |  |  | 2008-03-07 07:29:59
 |  |  | 2008-03-07 07:44:59
 |  |  | 2008-03-07 07:59:59
 |  |  | 2008-03-07 08:14:59
 |  |  | 2008-03-07 08:29:59
 |  |  | 2008-03-07 08:44:59
 |  |  | 2008-03-07 08:59:59
 |  |  | 2008-03-07 09:14:59
 |  |  | 2008-03-07 09:29:59
 |  |  | 2008-03-07 09:44:59
 |  |  | 2008-03-07 09:59:59
 |  |  | 2008-03-07 10:14:59
 |  |  | 2008-03-07 10:29:59
 |  |  | 2008-03-07 10:44:59
 |  |  | 2008-03-07 10:59:59
 |  |  | 2008-03-07 11:14:59
 |  |  | 2008-03-07 11:29:59
 |  |  | 2008-03-07 11:44:59
 |  |  | 2008-03-07 11:59:59
 |  |  | 2008-03-07 12:14:59
 |  |  | 2008-03-07 12:29:59
 |  |  | 2008-03-07 12:44:59
 |  |  | 2008-03-07 12:59:59
 |  |  | 2008-03-07 13:14:59
 |  |  | 2008-03-07 13:29:59
 |  |  | 2008-03-07 13:44:59
 |  |  | 2008-03-07 13:59:59
 |  |  | 2008-03-07 14:14:59
 |  |  | 2008-03-07 14:29:59
 |  |  | 2008-03-07 14:44:59
 |  |  | 2008-03-07 14:59:59
 |  |  | 2008-03-07 15:14:59
 |  |  | 2008-03-07 15:29:59
 |  |  | 2008-03-07 15:44:59
 |  |  | 2008-03-07 15:59:59
 |  |  | 2008-03-07 16:14:59
 |  |  | 2008-03-07 16:29:59
 |  |  | 2008-03-07 16:44:59
 |  |  | 2008-03-07 16:59:59
 |  |  | 2008-03-07 17:14:59
 |  |  | 2008-03-07 17:29:59
 |  |  | 2008-03-07 17:44:59
 |  |  | 2008-03-07 17:59:59
 |  |  | 2008-03-07 18:14:59
 |  |  | 2008-03-07 18:29:59
 |  |  | 2008-03-07 18:44:59
 |  |  | 2008-03-07 18:59:59
 |  |  | 2008-03-07 19:14:59
 |  |  | 2008-03-07 19:29:59
 |  |  | 2008-03-07 19:44:59
 |  |  | 2008-03-07 19:59:59
 |  |  | 2008-03-07 20:14:59
 |  |  | 2008-03-07 20:29:59
 |  |  | 2008-03-07 20:44:59
 |  |  | 2008-03-07 20:59:59
 |  |  | 2008-03-07 21:14:59
 |  |  | 2008-03-07 21:29:59
 |  |  | 2008-03-07 21:44:59
 |  |  | 2008-03-07 21:59:59
 |  |  | 2008-03-07 22:14:59
 |  |  | 2008-03-07 22:29:59
 |  |  | 2008-03-07 22:44:59
 |  |  | 2008-03-07 22:59:59
 |  |  | 2008-03-07 23:14:59
 |  |  | 2008-03-07 23:29:59
 |  |  | 2008-03-07 23:44:59
 |  |  | 2008-03-07 23:59:59
 |  |  | 2008-03-08 00:14:59
 |  |  | 2008-03-08 00:29:59
 |  |  | 2008-03-08 00:44:59
 |  |  | 2008-03-08 00:59:59
 |  |  | 2008-03-08 01:14:59
 |  |  | 2008-03-08 01:29:59
 |  |  | 2008-03-08 01:44:59
 |  |  | 2008-03-08 01:59:59
 |  |  | 2008-03-08 02:14:59
 |  |  | 2008-03-08 02:29:59
 |  |  | 2008-03-08 02:44:59
 |  |  | 2008-03-08 02:59:59
 |  |  | 2008-03-08 03:14:59
 |  |  | 2008-03-08 03:29:59
 |  |  | 2008-03-08 03:44:59
 |  |  | 2008-03-08 03:59:59
 |  |  | 2008-03-08 04:14:59
 |  |  | 2008-03-08 04:29:59
 |  |  | 2008-03-08 04:44:59
 |  |  | 2008-03-08 04:59:59
 |  |  | 2008-03-08 05:14:59
 |  |  | 2008-03-08 05:29:59
 |  |  | 2008-03-08 05:44:59
 |  |  | 2008-03-08 05:59:59
 |  |  | 2008-03-08 06:14:59
 |  |  | 2008-03-08 06:29:59
 |  |  | 2008-03-08 06:44:59
 |  |  | 2008-03-08 06:59:59
 |  |  | 2008-03-08 07:14:59
 |  |  | 2008-03-08 07:29:59
 |  |  | 2008-03-08 07:44:59
 |  |  | 2008-03-08 07:59:59
 |  |  | 2008-03-08 08:14:59
 |  |  | 2008-03-08 08:29:59
 |  |  | 2008-03-08 08:44:59
 |  |  | 2008-03-08 08:59:59
 |  |  | 2008-03-08 09:14:59
 |  |  | 2008-03-08 09:29:59
 |  |  | 2008-03-08 09:44:59
 |  |  | 2008-03-08 09:59:59
 |  |  | 2008-03-08 10:14:59
 |  |  | 2008-03-08 10:29:59
 |  |  | 2008-03-08 10:44:59
 |  |  | 2008-03-08 10:59:59
 |  |  | 2008-03-08 11:14:59
 |  |  | 2008-03-08 11:29:59
 |  |  | 2008-03-08 11:44:59
 |  |  | 2008-03-08 11:59:59
 |  |  | 2008-03-08 12:14:59
 |  |  | 2008-03-08 12:29:59
 |  |  | 2008-03-08 12:44:59
 |  |  | 2008-03-08 12:59:59
 |  |  | 2008-03-08 13:14:59
 |  |  | 2008-03-08 13:29:59
 |  |  | 2008-03-08 13:44:59
 |  |  | 2008-03-08 13:59:59
 |  |  | 2008-03-08 14:14:59
 |  |  | 2008-03-08 14:29:59
 |  |  | 2008-03-08 14:44:59
 |  |  | 2008-03-08 14:59:59
 |  |  | 2008-03-08 15:14:59
 |  |  | 2008-03-08 15:29:59
 |  |  | 2008-03-08 15:44:59
 |  |  | 2008-03-08 15:59:59
 |  |  | 2008-03-08 16:14:59
 |  |  | 2008-03-08 16:29:59
 |  |  | 2008-03-08 16:44:59
 |  |  | 2008-03-08 16:59:59
 |  |  | 2008-03-08 17:14:59
 |  |  | 2008-03-08 17:29:59
 |  |  | 2008-03-08 17:44:59
 |  |  | 2008-03-08 17:59:59
 |  |  | 2008-03-08 18:14:59
 |  |  | 2008-03-08 18:29:59
 |  |  | 2008-03-08 18:44:59
 |  |  | 2008-03-08 18:59:59
 |  |  | 2008-03-08 19:14:59
 |  |  | 2008-03-08 19:29:59
 |  |  | 2008-03-08 19:44:59
 |  |  | 2008-03-08 19:59:59
 |  |  | 2008-03-08 20:14:59
 |  |  | 2008-03-08 20:29:59
 |  |  | 2008-03-08 20:44:59
 |  |  | 2008-03-08 20:59:59
 |  |  | 2008-03-08 21:14:59
 |  |  | 2008-03-08 21:29:59
 |  |  | 2008-03-08 21:44:59
 |  |  | 2008-03-08 21:59:59
 |  |  | 2008-03-08 22:14:59
 |  |  | 2008-03-08 22:29:59
 |  |  | 2008-03-08 22:44:59
 |  |  | 2008-03-08 22:59:59
 |  |  | 2008-03-08 23:14:59
 |  |  | 2008-03-08 23:29:59
 |  |  | 2008-03-08 23:44:59
 |  |  | 2008-03-08 23:59:59
 |  |  | 2008-03-09 00:14:59
 |  |  | 2008-03-09 00:29:59
 |  |  | 2008-03-09 00:44:59
 |  |  | 2008-03-09 00:59:59
 |  |  | 2008-03-09 01:14:59
 |  |  | 2008-03-09 01:29:59
 |  |  | 2008-03-09 01:44:59
 |  |  | 2008-03-09 01:59:59
 |  |  | 2008-03-09 02:14:59
 |  |  | 2008-03-09 02:29:59
 |  |  | 2008-03-09 02:44:59
 |  |  | 2008-03-09 02:59:58
 |  |  | 2008-03-09 03:14:58
 |  |  | 2008-03-09 03:29:58
 |  |  | 2008-03-09 03:44:58
 |  |  | 2008-03-09 03:59:58
 |  |  | 2008-03-09 04:14:58
 |  |  | 2008-03-09 04:29:58
 |  |  | 2008-03-09 04:44:58
 |  |  | 2008-03-09 04:59:58
 |  |  | 2008-03-09 05:14:58
 |  |  | 2008-03-09 05:29:58
 |  |  | 2008-03-09 05:44:58
 |  |  | 2008-03-09 05:59:58
 |  |  | 2008-03-09 06:14:58
 |  |  | 2008-03-09 06:29:58
 |  |  | 2008-03-09 06:44:58
 |  |  | 2008-03-09 06:59:58
 |  |  | 2008-03-09 07:14:58
 |  |  | 2008-03-09 07:29:58
 |  |  | 2008-03-09 07:44:58
 |  |  | 2008-03-09 07:59:58
 |  |  | 2008-03-09 08:14:58
 |  |  | 2008-03-09 08:29:58
 |  |  | 2008-03-09 08:44:58
 |  |  | 2008-03-09 08:59:58
 |  |  | 2008-03-09 09:14:58
 |  |  | 2008-03-09 09:29:58
 |  |  | 2008-03-09 09:44:58
 |  |  | 2008-03-09 09:59:58
 |  |  | 2008-03-09 10:14:58
 |  |  | 2008-03-09 10:29:58
 |  |  | 2008-03-09 10:44:58
 |  |  | 2008-03-09 10:59:58
 |  |  | 2008-03-09 11:14:58
 |  |  | 2008-03-09 11:29:58
 |  |  | 2008-03-09 11:44:58
 |  |  | 2008-03-09 11:59:58
 |  |  | 2008-03-09 12:14:58
 |  |  | 2008-03-09 12:29:58
 |  |  | 2008-03-09 12:44:58
 |  |  | 2008-03-09 12:59:58
 |  |  | 2008-03-09 13:14:58
 |  |  | 2008-03-09 13:29:58
 |  |  | 2008-03-09 13:44:58
 |  |  | 2008-03-09 13:59:58
 |  |  | 2008-03-09 14:14:58
 |  |  | 2008-03-09 14:29:58
 |  |  | 2008-03-09 14:44:58
 |  |  | 2008-03-09 14:59:58
 |  |  | 2008-03-09 15:14:58
 |  |  | 2008-03-09 15:29:58
 |  |  | 2008-03-09 15:44:58
 |  |  | 2008-03-09 15:59:58
 |  |  | 2008-03-09 16:14:58
 |  |  | 2008-03-09 16:29:58
 |  |  | 2008-03-09 16:44:58
 |  |  | 2008-03-09 16:59:58
 |  |  | 2008-03-09 17:14:58
 |  |  | 2008-03-09 17:29:58
 |  |  | 2008-03-09 17:44:58
 |  |  | 2008-03-09 17:59:58
 |  |  | 2008-03-09 18:14:58
 |  |  | 2008-03-09 18:29:58
 |  |  | 2008-03-09 18:44:58
 |  |  | 2008-03-09 18:59:58
 |  |  | 2008-03-09 19:14:58
 |  |  | 2008-03-09 19:29:58
 |  |  | 2008-03-09 19:44:58
 |  |  | 2008-03-09 19:59:58
 |  |  | 2008-03-09 20:14:58
 |  |  | 2008-03-09 20:29:58
 |  |  | 2008-03-09 20:44:58
 |  |  | 2008-03-09 20:59:58
 |  |  | 2008-03-09 21:14:58
 |  |  | 2008-03-09 21:29:58
 |  |  | 2008-03-09 21:44:58
 |  |  | 2008-03-09 21:59:58
 |  |  | 2008-03-09 22:14:58
 |  |  | 2008-03-09 22:29:58
 |  |  | 2008-03-09 22:44:58
 |  |  | 2008-03-09 22:59:58
 |  |  | 2008-03-09 23:14:58
 |  |  | 2008-03-09 23:29:58
 |  |  | 2008-03-09 23:44:58
 |  |  | 2008-03-09 23:59:58