Spreadsheet: 65298d1265984067-excel-2007-pivot-tables-sum-over-24hrs-for-hh-mm-pit-stop-calculation-2010-master-file-pt-problem
Sheet: station details

Sum of Recovery2 | Week
DEST | 1 | 2 | 3 | 4 | Grand Total
DOH |  |  | 1912-01-03 00:40:00 | 1912-01-03 00:18:00 | 1920-01-05 00:58:00
ABJ |  |  |  | 1908-01-02 00:23:00 | 1908-01-02 00:23:00
ACC |  | 1908-01-02 00:00:00 |  | 1912-01-03 00:14:00 | 1916-01-04 00:14:00
AKL |  | 1908-01-02 00:05:00 |  | 1908-01-02 00:05:00 | 1912-01-03 00:10:00
ALA |  | 1916-01-04 00:00:00 | 1924-01-06 00:00:00 | 1944-01-11 23:06:00 | 1976-01-19 23:06:00
[NAME] | 1908-01-02 00:19:00 | 1908-01-02 00:00:00 | 1912-01-03 00:29:00 |  | 1920-01-05 00:48:00
AMS |  |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00
ATL |  | 1916-01-04 01:17:00 | 1916-01-04 01:03:00 | 1912-01-03 00:33:00 | 1936-01-09 02:53:00
AUH |  |  | 1908-01-02 00:24:00 | 1908-01-02 00:00:00 | 1912-01-03 00:24:00
BCN | 1908-01-02 00:00:00 |  | 1912-01-03 00:04:00 | 1912-01-03 00:07:00 | 1924-01-06 00:11:00
[NAME] |  | 1908-01-02 00:00:00 |  |  | 1908-01-02 00:00:00
BEY | 1908-01-02 00:34:00 | 1908-01-02 00:08:00 | 1916-01-04 01:17:00 | 1908-01-02 00:14:00 | 1928-01-07 02:13:00
BKK | 1912-01-03 00:00:00 | 1916-01-04 00:01:00 | 1924-01-06 00:00:00 | 1920-01-05 00:37:00 | 1960-01-15 00:38:00
BOG | 1916-01-04 00:29:00 | 1908-01-02 00:59:00 | 1912-01-03 00:41:00 | 1916-01-04 00:29:00 | 1940-01-10 02:38:00
BRU |  |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00
BUD |  | 1912-01-03 00:00:00 | 1912-01-03 00:00:00 | 1908-01-02 01:03:00 | 1924-01-06 01:03:00
BZV |  |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00
CUR | 1916-01-04 00:25:00 | 1912-01-03 00:25:00 | 1912-01-03 00:40:00 | 1920-01-05 01:10:00 | 1948-01-12 02:40:00
CWB | 1912-01-03 00:30:00 | 1908-01-02 00:05:00 | 1908-01-02 00:29:00 | 1912-01-03 00:45:00 | 1928-01-07 01:49:00
DAM |  | 1908-01-02 00:00:00 | 1908-01-02 00:06:00 | 1912-01-03 00:29:00 | 1920-01-05 00:35:00
DMM |  |  |  | 1908-01-02 00:21:00 | 1908-01-02 00:21:00
DXB | 1912-01-03 00:26:00 |  | 1928-01-07 02:59:00 | 1924-01-06 02:33:00 | 1956-01-14 05:58:00
FIH | 1908-01-02 00:04:00 |  |  | 1912-01-03 00:35:00 | 1916-01-04 00:39:00
GDL |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:08:00 | 1912-01-03 00:08:00
GYD | 1920-01-05 00:23:00 | 1936-01-09 03:20:00 | 1984-01-21 06:10:00 | 1984-01-21 04:36:00 | 2112-02-23 14:29:00
HKG | 1912-01-03 00:54:00 | 1916-01-04 00:13:00 | 1932-01-08 06:38:00 | 1936-01-09 07:43:00 | 1984-01-21 15:28:00
HSV |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1908-01-02 00:08:00 | 1916-01-04 00:08:00
IAH |  | 1916-01-04 00:15:00 | 1924-01-06 01:32:00 | 1920-01-05 01:35:00 | 1952-01-13 03:22:00
ICN |  |  |  | 1908-01-02 00:08:00 | 1908-01-02 00:08:00
IND |  | 1912-01-03 00:40:00 | 1908-01-02 00:25:00 | 1912-01-03 00:24:00 | 1924-01-06 01:29:00
[NAME] |  | 1916-01-04 01:02:00 | 1940-01-10 00:39:00 | 1936-01-09 05:12:00 | 1984-01-21 06:53:00
JNB |  |  |  | 1912-01-03 00:00:00 | 1912-01-03 00:00:00
KHI |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:20:00 | 1912-01-03 00:20:00
KMQ |  |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00
KUL | 1908-01-02 00:53:00 | 1908-01-02 00:00:00 |  | 1912-01-03 00:56:00 | 1920-01-05 01:49:00
KWI |  | 1912-01-03 01:58:00 | 1908-01-02 00:16:00 | 1912-01-03 00:23:00 | 1924-01-06 02:37:00
LAX | 1908-01-02 00:35:00 | 1920-01-05 01:46:00 | 1920-01-05 01:28:00 | 1924-01-06 01:17:00 | 1960-01-15 05:06:00
LBV | 1908-01-02 00:09:00 |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1916-01-04 00:09:00
LOS |  | 1912-01-03 00:05:00 | 1908-01-02 00:14:00 | 1920-01-05 00:26:00 | 1932-01-08 00:45:00
LUX | 1928-01-07 01:44:00 | 1980-01-20 01:44:00 | 2012-01-28 05:53:00 | 2052-02-07 05:59:00 | 2260-04-01 15:20:00
[NAME] |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1908-01-02 00:23:00 | 1916-01-04 00:23:00
MEX |  | 1908-01-02 00:33:00 | 1924-01-06 02:11:00 | 1920-01-05 00:57:00 | 1944-01-11 03:41:00
MIA |  | 1908-01-02 00:38:00 | 1912-01-03 01:02:00 | 1908-01-02 00:38:00 | 1920-01-05 02:18:00
MSE | 1908-01-02 00:07:00 | 1908-01-02 00:11:00 | 1908-01-02 00:00:00 | 1912-01-03 00:57:00 | 1924-01-06 01:15:00
MST |  | 1908-01-02 00:00:00 | 1912-01-03 00:53:00 | 1916-01-04 00:37:00 | 1928-01-07 01:30:00
MXP | 1912-01-03 00:00:00 |  | 1920-01-05 01:15:00 | 1936-01-09 04:03:00 | 1960-01-15 05:18:00
NBO | 1908-01-02 00:00:00 | 1912-01-03 00:01:00 | 1916-01-04 03:25:00 | 1928-01-07 00:00:00 | 1952-01-13 03:26:00
NDJ |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1912-01-03 00:00:00
ORD |  | 1912-01-03 00:13:00 | 1916-01-04 00:47:00 | 1916-01-04 00:00:00 | 1936-01-09 01:00:00
PEK | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 |  | 1916-01-04 00:00:00
PIK |  | 1920-01-05 00:13:00 | 1924-01-06 01:39:00 | 1932-01-08 02:48:00 | 1968-01-17 04:40:00
PNZ |  |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00
PTY |  |  | 1908-01-02 00:00:00 | 1908-01-02 00:00:00 | 1912-01-03 00:00:00
PVG |  | 1912-01-03 00:00:00 | 1928-01-07 00:44:00 | 1928-01-07 00:02:00 | 1960-01-15 00:46:00
REC |  |  | 1908-01-02 00:05:00 |  | 1908-01-02 00:05:00
SAW |  |  | 1912-01-03 00:00:00 |  | 1912-01-03 00:00:00
SCL |  |  | 1908-01-02 00:03:00 | 1908-01-02 00:00:00 | 1912-01-03 00:03:00
SEA | 1908-01-02 00:33:00 | 1912-01-03 00:00:00 | 1920-01-05 00:55:00 | 1920-01-05 00:00:00 | 1948-01-12 01:28:00
SGN |  |  | 1908-01-02 00:06:00 | 1912-01-03 00:24:00 | 1916-01-04 00:30:00
SHJ |  | 1908-01-02 00:21:00 | 1908-01-02 00:15:00 | 1908-01-02 00:19:00 | 1916-01-04 00:55:00
SIN | 1908-01-02 00:00:00 | 1912-01-03 00:49:00 | 1912-01-03 01:12:00 | 1920-01-05 01:37:00 | 1940-01-10 03:38:00
STN |  |  | 1908-01-02 00:20:00 |  | 1908-01-02 00:20:00
TBS |  |  | 1908-01-02 00:05:00 | 1908-01-02 00:16:00 | 1912-01-03 00:21:00
TLS |  |  | 1912-01-03 00:09:00 |  | 1912-01-03 00:09:00
TPE | 1908-01-02 00:53:00 | 1908-01-02 00:14:00 | 1912-01-03 01:10:00 | 1912-01-03 00:41:00 | 1928-01-07 02:58:00
UIO | 1916-01-04 00:00:00 | 1912-01-03 00:00:00 | 1912-01-03 00:00:00 | 1916-01-04 00:18:00 | 1944-01-11 00:18:00
VCP | 1912-01-03 00:36:00 | 1912-01-03 00:01:00 | 1908-01-02 00:00:00 | 1912-01-03 00:36:00 | 1932-01-08 01:13:00
XMN | 1908-01-02 00:00:00 | 1908-01-02 00:27:00 | 1908-01-02 00:08:00 |  | 1916-01-04 00:35:00
YYC |  | 1908-01-02 00:08:00 | 1908-01-02 00:42:00 | 1912-01-03 00:34:00 | 1920-01-05 01:24:00
Grand Total | 2084-02-15 09:34:00 | 2292-04-09 17:52:00 | 2600-06-30 01:13:00 | 2764-08-12 05:27:00 | 4029-07-06 10:06:00
 |  |  |  | 2006-02-09 08:20:00 | 2006-02-09 19:34:00
 |  |  |  |  | 2008-06-11 18:44:00
 |  |  |  |  |  |  |  |  |  | 00:36:00