Spreadsheet: 169234d1342735576-excel-2007-calculating-ontime-late-one-date-has-time-other-doesnt-skewing-results-date-problem
Sheet: Sheet1

Forecast Date | Actual Date | Early/Late
2012-06-25 00:00:00 | 2012-06-20 13:36:00 | 4.433333333334303
2012-06-26 00:00:00 | 2012-07-06 16:45:00 | -10.69791666666424
2012-06-26 00:00:00 | 2012-06-30 15:12:00 | -4.633333333331393
2012-06-26 00:00:00 | 2012-06-25 17:35:00 | 0.2673611111094942
2012-06-26 00:00:00 | 2012-06-22 14:38:00 | 3.390277777776646
2012-06-26 00:00:00 | 2012-07-02 11:33:00 | -6.48124999999709
2012-06-28 00:00:00 | 2012-06-25 10:27:00 | 2.564583333332848
2012-06-28 00:00:00 | 2012-07-03 10:31:00 | -5.438194444446708
2012-06-28 00:00:00 | 2012-07-02 11:37:00 | -4.484027777776646
2012-06-29 00:00:00 | 2012-06-26 13:11:00 | 2.450694444443798
2012-06-29 00:00:00 | 2012-06-11 15:05:00 | 17.37152777778101
2012-06-29 00:00:00 | 2012-07-02 10:14:00 | -3.426388888889051
2012-06-29 00:00:00 | 2012-06-29 11:27:00 | -0.4770833333313931
2012-06-29 00:00:00 | 2012-06-29 11:50:00 | -0.4930555555547471
2012-06-29 00:00:00 | 2012-06-29 12:06:00 | -0.5041666666656965
2012-06-29 00:00:00 | 2012-06-29 11:40:00 | -0.4861111111094942
2012-06-29 00:00:00 | 2012-06-29 11:59:00 | -0.4993055555532919
2012-06-29 00:00:00 | 2012-06-27 09:29:00 | 1.604861111110949
2012-06-29 00:00:00 | 2012-07-03 15:31:00 | -4.646527777775191
2012-06-29 00:00:00 | 2012-03-22 13:29:00 | 98.43819444444671
2012-07-02 00:00:00 | 2012-07-03 15:59:00 | -1.665972222224809
2012-06-28 00:00:00
2012-06-28 00:00:00
2012-07-02 00:00:00 | 2012-07-02 10:54:00 | -0.4541666666700621
2012-07-03 00:00:00 | 2012-06-29 15:38:00 | 3.348611111112405
2012-07-03 00:00:00
2012-07-05 00:00:00 | 2012-06-01 18:44:00 | 33.21944444444671
2012-07-05 00:00:00 | 2012-07-06 17:10:00 | -1.715277777781012
2012-07-05 00:00:00 | 2012-07-10 15:32:00 | -5.647222222221899
2012-07-03 00:00:00 | 2012-07-06 17:16:00 | -3.719444444446708
2012-07-05 00:00:00 | 2012-07-06 16:57:00 | -1.70625000000291
2012-07-05 00:00:00 | 2012-07-11 13:45:00 | -6.572916666664241
2012-07-05 00:00:00 | 2012-07-05 16:13:00 | -0.6756944444423425
2012-07-05 00:00:00 | 2012-07-12 17:08:00 | -7.713888888887595
2012-07-05 00:00:00 | 2012-07-12 17:09:00 | -7.714583333334303
2012-07-05 00:00:00 | 2012-07-12 17:10:00 | -7.715277777781012
2012-07-05 00:00:00 | 2012-07-03 13:06:00 | 1.454166666670062
2012-07-05 00:00:00 | 2012-07-05 15:29:00 | -0.6451388888890506
2012-07-05 00:00:00 | 2012-07-11 10:01:00 | -6.417361111110949
2012-07-05 00:00:00 | 2012-07-05 14:30:00 | -0.6041666666642413
2012-07-05 00:00:00 | 2012-07-06 17:08:00 | -1.713888888887595
2012-07-06 00:00:00 | 2012-07-11 14:26:00 | -5.601388888891961
2012-07-06 00:00:00 | 2012-07-03 13:33:00 | 2.435416666667152
2012-07-04 00:00:00 | 2012-06-29 15:39:00 | 4.347916666665697
2012-07-06 00:00:00 | 2012-07-05 16:53:00 | 0.296527777776646
2012-07-06 00:00:00 | 2012-07-06 17:16:00 | -0.7194444444467081
2012-07-06 00:00:00 | 2012-07-03 14:35:00 | 2.392361111109494
2012-07-05 00:00:00 | 2012-06-29 15:39:00 | 5.347916666665697
2012-07-10 00:00:00 | 2012-07-12 18:09:00 | -2.756249999998545
2012-07-06 00:00:00 | 2012-07-11 09:19:00 | -5.388194444443798
2012-07-10 00:00:00 | 2012-07-10 18:20:00 | -0.7638888888905058
2012-07-10 00:00:00 | 2012-07-16 16:40:00 | -6.694444444445253
2012-07-10 00:00:00 | 2012-07-16 16:39:00 | -6.693749999998545
2012-07-10 00:00:00 | 2012-07-10 17:52:00 | -0.7444444444408873
2012-07-10 00:00:00 | 2012-07-10 18:00:00 | -0.75
2012-07-10 00:00:00 | 2012-07-09 14:22:00 | 0.4013888888875954
2012-07-10 00:00:00 | 2012-07-10 18:06:00 | -0.7541666666656965
2012-07-11 00:00:00 | 2012-07-06 17:11:00 | 4.284027777779556
2012-07-11 00:00:00 | 2012-07-11 18:38:00 | -0.7763888888875954
2012-07-11 00:00:00 | 2012-07-06 16:40:00 | 4.305555555554747
2012-07-11 00:00:00 | 2012-07-11 13:39:00 | -0.5687499999985448
2012-07-11 00:00:00 | 2012-07-03 17:48:00 | 7.258333333331393
2012-07-11 00:00:00 | 2012-07-16 16:36:00 | -5.691666666665697
2012-07-11 00:00:00 | 2012-07-16 16:35:00 | -5.690972222218988
2012-07-11 00:00:00 | 2012-07-16 16:34:00 | -5.690277777779556
2012-07-11 00:00:00 | 2012-06-28 12:49:00 | 12.46597222222044
2012-07-11 00:00:00 | 2012-07-06 16:18:00 | 4.320833333331393
2012-07-11 00:00:00 | 2012-06-28 12:49:00 | 12.46597222222044
2012-07-11 00:00:00 | 2012-07-06 16:51:00 | 4.297916666670062
2012-07-11 00:00:00 | 2012-07-06 16:38:00 | 4.306944444440887
2012-07-11 00:00:00 | 2012-07-02 18:14:00 | 8.24027777777519
2012-07-11 00:00:00 | 2012-07-02 18:13:00 | 8.240972222221899
2012-07-11 00:00:00 | 2012-07-02 18:14:00 | 8.24027777777519
2012-07-12 00:00:00 | 2012-07-09 15:25:00 | 2.357638888890506
2012-07-13 00:00:00 | 2012-07-11 10:07:00 | 1.578472222223354
2012-07-11 00:00:00 | 2012-07-07 17:00:00 | 3.291666666664241
2012-07-13 00:00:00 | 2012-07-16 20:20:00 | -3.847222222218988
2012-07-13 00:00:00 | 2012-07-12 14:26:00 | 0.398611111108039
2012-07-13 00:00:00 | 2012-07-12 14:25:00 | 0.3993055555547471
2012-07-13 00:00:00 | 2012-07-12 14:28:00 | 0.3972222222218988
2012-07-13 00:00:00 | 2012-07-13 11:57:00 | -0.4979166666671517
2012-07-13 00:00:00 | 2012-07-13 11:49:00 | -0.492361111108039
2012-07-11 00:00:00 | 2012-07-16 16:41:00 | -5.695138888891961
2012-07-13 00:00:00 | 2012-07-12 16:11:00 | 0.3256944444437977
2012-07-13 00:00:00 | 2012-07-12 16:01:00 | 0.3326388888890506
2012-07-13 00:00:00 | 2012-07-16 16:21:00 | -3.681250000001455
2012-07-12 00:00:00 | 2012-06-12 11:18:00 | 29.52916666666715
2012-07-16 00:00:00 | 2012-07-04 17:29:00 | 11.27152777777519
2012-07-17 00:00:00 | 2012-07-13 19:25:00 | 3.190972222218988
2012-07-17 00:00:00 | 2012-07-13 13:43:00 | 3.428472222221899
2012-07-18 00:00:00 | 2012-07-13 16:48:00 | 4.30000000000291
2012-07-18 00:00:00 | 2012-07-13 16:49:00 | 4.299305555556202
2012-07-19 00:00:00 | 2012-07-10 10:17:00 | 8.571527777778101
2012-07-19 00:00:00 | 2012-07-16 19:51:00 | 2.172916666670062
2012-07-19 00:00:00 | 2012-07-16 19:52:00 | 2.172222222223354
2012-07-19 00:00:00 | 2012-07-16 19:54:00 | 2.170833333329938
2012-07-17 00:00:00 | 2012-07-16 17:53:00 | 0.2548611111124046
2012-07-17 00:00:00 | 2012-07-13 13:43:00 | 3.428472222221899
2012-07-17 00:00:00 | 2012-07-13 13:43:00 | 3.428472222221899
2012-07-17 00:00:00 | 2012-07-16 17:55:00 | 0.2534722222189885
2012-07-19 00:00:00 | 2012-07-10 11:52:00 | 8.505555555559113
2012-07-20 00:00:00
2012-07-23 00:00:00
2012-07-23 00:00:00
2012-07-23 00:00:00
2012-07-23 00:00:00
2012-07-23 00:00:00
2012-07-23 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-24 00:00:00
2012-07-25 00:00:00
2012-07-25 00:00:00
2012-07-25 00:00:00
2012-07-25 00:00:00
2012-07-25 00:00:00
2012-07-26 00:00:00
2012-07-24 00:00:00
2012-07-26 00:00:00
2012-07-27 00:00:00
2012-07-25 00:00:00
2012-07-27 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-30 00:00:00
2012-07-31 00:00:00
2012-07-31 00:00:00
2012-07-31 00:00:00
2012-07-30 00:00:00
2012-08-02 00:00:00
2012-08-02 00:00:00
2012-08-02 00:00:00
2012-08-02 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-01 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-03 00:00:00
2012-08-06 00:00:00
2012-08-07 00:00:00
2012-08-07 00:00:00
2012-08-07 00:00:00
2012-08-07 00:00:00
2012-08-06 00:00:00
2012-08-08 00:00:00
2012-08-07 00:00:00
2012-08-07 00:00:00
2012-08-07 00:00:00
2012-08-10 00:00:00
2012-08-21 00:00:00
2012-08-20 00:00:00
2012-08-22 00:00:00
2012-08-24 00:00:00
2012-08-24 00:00:00
2012-08-24 00:00:00
2012-08-24 00:00:00
2012-08-24 00:00:00
2012-08-24 00:00:00
2012-08-30 00:00:00
2012-09-04 00:00:00
2012-09-19 00:00:00
2012-09-21 00:00:00
2012-10-22 00:00:00