Spreadsheet: 107964d1305090778-combining-different-time-intervals-book4
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Price (hourly)
 | Price (minutes) | Price (hourly) |  |  |  |  |  | 2011-04-28 14:15:00 | 23992.31
2011-05-06 14:55:00 | 23170.28 |  |  |  |  |  |  | 2011-04-28 15:15:00 | 23775.36
2011-05-06 14:56:00 | 23166.11 |  |  |  |  |  |  | 2011-04-29 09:15:00 | 23774.47
2011-05-06 14:57:00 | 23170.55 |  |  |  |  |  |  | 2011-04-29 10:15:00 | 23747.8
2011-05-06 14:58:00 | 23173.32 |  |  |  |  |  |  | 2011-04-29 11:15:00 | 23718.1
2011-05-06 14:59:00 | 23173.97 |  |  |  |  |  |  | 2011-04-29 13:15:00 | 23688.43
2011-05-06 15:00:00 | 23174.98 |  |  |  |  |  |  | 2011-04-29 14:15:00 | 23760.76
2011-05-06 15:01:00 | 23177.94 |  |  |  |  |  |  | 2011-04-29 15:15:00 | 23678.58
2011-05-06 15:02:00 | 23175.21 |  |  |  |  |  |  | 2011-05-03 09:15:00 | 23794.86
2011-05-06 15:03:00 | 23172.31 |  |  |  |  |  |  | 2011-05-03 10:15:00 | 23737.37
2011-05-06 15:04:00 | 23175.64 |  |  |  |  |  |  | 2011-05-03 11:15:00 | 23744.73
2011-05-06 15:05:00 | 23171.12 |  |  |  |  |  |  | 2011-05-03 13:15:00 | 23776.87
2011-05-06 15:06:00 | 23166.37 |  |  |  |  |  |  | 2011-05-03 14:15:00 | 23766.03
2011-05-06 15:07:00 | 23167.88 |  |  |  |  |  |  | 2011-05-03 15:15:00 | 23728.81
2011-05-06 15:08:00 | 23160.98 |  |  |  |  |  |  | 2011-05-04 09:15:00 | 23582.6
2011-05-06 15:09:00 | 23165.73 |  |  |  |  |  |  | 2011-05-04 10:15:00 | 23385.59
2011-05-06 15:10:00 | 23154.91 |  |  |  |  |  |  | 2011-05-04 11:15:00 | 23318.7
2011-05-06 15:11:00 | 23152.1 |  |  |  |  |  |  | 2011-05-04 13:15:00 | 23315.64
2011-05-06 15:12:00 | 23150.03 |  |  |  |  |  |  | 2011-05-04 14:15:00 | 23250.05
2011-05-06 15:13:00 | 23152.45 |  |  |  |  |  |  | 2011-05-04 15:15:00 | 23284.99
2011-05-06 15:14:00 | 23152.71 |  |  |  |  |  |  | 2011-05-05 09:15:00 | 23228.01
2011-05-06 15:15:00 | 23152.54 |  |  |  |  |  |  | 2011-05-05 10:15:00 | 23251.53
2011-05-06 15:16:00 | 23152.45 |  |  |  |  |  |  | 2011-05-05 11:15:00 | 23250.96
2011-05-06 15:17:00 | 23149.67 |  |  |  |  |  |  | 2011-05-05 13:15:00 | 23316.4
 |  |  |  |  |  |  |  | 2011-05-05 14:15:00 | 23316.32
 |  |  |  |  |  |  |  | 2011-05-05 15:15:00 | 23227.07
 |  |  |  |  |  |  |  | 2011-05-06 09:15:00 | 23035.94
 |  |  |  |  |  |  |  | 2011-05-06 10:15:00 | 23141.32
 |  |  |  |  |  |  |  | 2011-05-06 11:15:00 | 23110.33
 |  |  |  |  |  |  |  | 2011-05-06 13:15:00 | 23135.51
 |  |  |  |  |  |  |  | 2011-05-06 14:15:00 | 23147.87
 |  |  |  |  |  |  |  | 2011-05-06 15:15:00 | 23152.54
 |  |  |  |  |  |  |  | 2011-05-09 09:15:00 | 23239.15
 |  |  |  |  |  |  |  | 2011-05-09 10:15:00 | 23310.19
 |  |  |  |  |  |  |  | 2011-05-09 11:15:00 | 23366.97
 |  |  |  |  |  |  |  | 2011-05-09 13:15:00 | 23371.35
 |  |  |  |  |  |  |  | 2011-05-09 14:15:00 | 23277.13
 |  |  |  |  |  |  |  | 2011-05-09 15:15:00 | 23311.9
 |  |  |  |  |  |  |  | 2011-05-11 09:15:00 | 23509.01
 |  |  |  |  |  |  |  | 2011-05-11 10:15:00 | 23283.14
 |  |  |  |  |  |  |  | 2011-05-11 11:15:00 | 23331.29
 |  |  |  |  |  |  |  | 2011-04-28 14:15:00 | 23992.31
 |  |  |  |  |  |  |  | 2011-04-28 15:15:00 | 23775.36
 |  |  |  |  |  |  |  | 2011-04-29 09:15:00 | 23774.47
 |  |  |  |  |  |  |  | 2011-04-29 10:15:00 | 23747.8
 |  |  |  |  |  |  |  | 2011-04-29 11:15:00 | 23718.1
 |  |  |  |  |  |  |  | 2011-04-29 13:15:00 | 23688.43
 |  |  |  |  |  |  |  | 2011-04-29 14:15:00 | 23760.76
 |  |  |  |  |  |  |  | 2011-04-29 15:15:00 | 23678.58
 |  |  |  |  |  |  |  | 2011-05-03 09:15:00 | 23794.86
 |  |  |  |  |  |  |  | 2011-05-03 10:15:00 | 23737.37
 |  |  |  |  |  |  |  | 2011-05-03 11:15:00 | 23744.73
 |  |  |  |  |  |  |  | 2011-05-03 13:15:00 | 23776.87
 |  |  |  |  |  |  |  | 2011-05-03 14:15:00 | 23766.03
 |  |  |  |  |  |  |  | 2011-05-03 15:15:00 | 23728.81
 |  |  |  |  |  |  |  | 2011-05-04 09:15:00 | 23582.6
 |  |  |  |  |  |  |  | 2011-05-04 10:15:00 | 23385.59
 |  |  |  |  |  |  |  | 2011-05-04 11:15:00 | 23318.7
 |  |  |  |  |  |  |  | 2011-05-04 13:15:00 | 23315.64
 |  |  |  |  |  |  |  | 2011-05-04 14:15:00 | 23250.05
 |  |  |  |  |  |  |  | 2011-05-04 15:15:00 | 23284.99
 |  |  |  |  |  |  |  | 2011-05-05 09:15:00 | 23228.01
 |  |  |  |  |  |  |  | 2011-05-05 10:15:00 | 23251.53
 |  |  |  |  |  |  |  | 2011-05-05 11:15:00 | 23250.96
 |  |  |  |  |  |  |  | 2011-05-05 13:15:00 | 23316.4
 |  |  |  |  |  |  |  | 2011-05-05 14:15:00 | 23316.32
 |  |  |  |  |  |  |  | 2011-05-05 15:15:00 | 23227.07
 |  |  |  |  |  |  |  | 2011-05-06 09:15:00 | 23035.94
 |  |  |  |  |  |  |  | 2011-05-06 10:15:00 | 23141.32
 |  |  |  |  |  |  |  | 2011-05-06 11:15:00 | 23110.33
 |  |  |  |  |  |  |  | 2011-05-06 13:15:00 | 23135.51
 |  |  |  |  |  |  |  | 2011-05-06 14:15:00 | 23147.87
 |  |  |  |  |  |  |  | 2011-05-06 15:15:00 | 23152.54