Spreadsheet: 296523d1392118593-if-match-times-by-columns-in-other-tabs-cdrs-test2-new
Sheet: CDRS Test

Call Type | Call Date | Call Time | Duration | Description | Time Band | ChargeCode | Salesprice |  | Cost Amount
Call 1 | 2014-01-01 00:00:00 | 22:29:43 | 00:00:08 | UK Mobile O2 (fm1) | OffPeak | 1193 | 0.0024 |  | 0.003466666666666667
Call 2 | 2014-01-02 00:00:00 | 11:05:13 | 00:02:34 | UK London | Peak | 1289 | 0.0129 |  | #N/A
Call 3 | 2014-01-02 00:00:00 | 12:27:04 | 00:05:14 | UK Birmingham | Peak | 1289 | 0.0262 |  | #N/A
Call 4 | 2014-01-02 00:00:00 | 12:47:29 | 00:00:56 | 0845 Lo-Call Non Geo (ll) | Peak | 1266 | 0.0677 |  | 0.02986666666666667
Call 5 | 2014-01-02 00:00:00 | 12:50:05 | 00:01:41 | 0845 Lo-Call Non Geo (ll) | Peak | 1266 | 0.094 |  | 0.05386666666666667
Call 6 | 2014-01-02 00:00:00 | 14:26:04 | 00:01:33 | 03 Uk Wide Number Calls (g21) | Peak | 1184 | 0.0104 |  | 0.011935
Call 7 | 2014-01-02 00:00:00 | 14:27:55 | 00:10:44 | 0845 Lo-Call Non Geo (ll) | Peak | 1266 | 0.4107 |  | 0.3434666666666666
Call 8 | 2014-01-03 00:00:00 | 13:26:48 | 00:07:21 | 0845 Lo-Call Non Geo (ll) | Peak | 1266 | 0.2923 |  | 0.2352
Call 9 | 2014-01-03 00:00:00 | 16:35:27 | 00:00:01 | UK Wolverhampton | Peak | 1289 | 0.0001 |  | #N/A
Call 10 | 2014-01-04 00:00:00 | 12:06:20 | 00:00:04 | UK Mobile O2 (fm1) | WeekendPeak | 1193 | 0.0012 |  | 0.001733333333333333
Call 11 | 2014-01-05 00:00:00 | 12:10:05 | 00:01:35 | UK Southampton | WeekendPeak | 1289 | 0.008 |  | #N/A
Call 12 | 2014-01-05 00:00:00 | 16:20:12 | 00:00:02 | UK Wolverhampton | WeekendPeak | 1289 | 0.0002 |  | #N/A
Call 13 | 2014-01-06 00:00:00 | 08:51:15 | 00:00:07 | UK London | Peak | 1289 | 0.0006 |  | #N/A
Call 14 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:05 | UK Worcester | Peak | 1289 | 0.0005 |  | #N/A
Call 15 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:08 | UK London | Peak | 1289 | 0.0007 |  | #N/A
Call 16 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:26 | UK Oldmeldrum | Peak | 1289 | 0.0022 |  | #N/A
Call 17 | 2014-01-06 00:00:00 | 09:04:21 | 00:04:29 | UK London | Peak | 1289 | 0.0225
Call 18 | 2014-01-06 00:00:00 | 09:55:32 | 00:00:08 | UK Mobile O2 (fm1) | Peak | 1193 | 0.0024
Call 19 | 2014-01-06 00:00:00 | 10:00:36 | 00:00:03 | UK London | Peak | 1289 | 0.0003
Call 20 | 2014-01-06 00:00:00 | 10:00:36 | 00:00:03 | UK Neath | Peak | 1289 | 0.0003
Call 21 | 2014-01-06 00:00:00 | 10:00:50 | 00:00:15 | UK Medway | Peak | 1289 | 0.0013
Call 22 | 2014-01-06 00:00:00 | 10:05:18 | 00:00:02 | UK Shrewsbury | Peak | 1289 | 0.0002
Call 23 | 2014-01-06 00:00:00 | 10:05:39 | 00:00:07 | UK Falkirk | Peak | 1289 | 0.0006
Call 24 | 2014-01-06 00:00:00 | 10:05:40 | 00:00:36 | UK Walsall | Peak | 1289 | 0.003
Call 25 | 2014-01-06 00:00:00 | 10:05:59 | 00:00:05 | UK Holyhead | Peak | 1289 | 0.0005
Call 26 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:03 | UK Motherwell | Peak | 1289 | 0.0003
Call 27 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:02 | UK Leeds | Peak | 1289 | 0.0002
Call 28 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:03 | UK Colchester | Peak | 1289 | 0.0003
Call 29 | 2014-01-06 00:00:00 | 10:06:21 | 00:00:05 | UK Reading | Peak | 1289 | 0.0005
Call 30 | 2014-01-06 00:00:00 | 10:06:29 | 00:00:08 | UK Ellon | Peak | 1289 | 0.0007
Call 31 | 2014-01-06 00:00:00 | 10:06:32 | 00:00:04 | UK Barrow-in-Furness | Peak | 1289 | 0.0004