Spreadsheet: 165013d1340985940-excel-2007-how-to-manipulate-array-that-displays-12-00-am-to-a-blank-sample
Sheet: Sheet1

Los Angeles_20120629091335691 | 10:13:00
Louisiana1_20120629073527650 | 08:37:00
Memphis1_20120629081235316 | 09:17:00
Detroit2_20120629090223190 | 10:02:00
Detroit_20120629082412803 | 09:28:00
Dallas1_20120629092404614 | 10:24:00
Dallas2_20120629092415317 | 10:24:00
Charlotte1_20120629090813214 | 10:08:00
Albuquerque2_20120629092400535 | 10:24:00
OAP All_DY1_20120629072814389 | 08:32:00
OAP All_DY_20120629071947782 | 08:21:00
OAP All_WE1_20120629072854187 | 08:32:00
OAP All_WE_20120629072023314 | 08:21:00
OAP All_WY1_20120629072925406 | 08:32:00
OAP All_WY_20120629072210880 | 08:26:00
ARAC_Central1_20120629082352568 | 09:28:00
ARAC_Central2_20120629082401553 | 09:28:00
ARAC_SE1_20120629075238161 | 08:56:00
ARAC_SE2_20120629075254755 | 08:56:00
ARAC_SW1_20120629075422960 | 08:56:00
ARAC_SW2_20120629075946219 | 09:01:00
ARAC_Western1_20120629082932514 | 09:33:00
ARAC_Western2_20120629083101548 | 09:33:00
Opaque Skinny_1_20120629000707390 | 01:08:00
Opaque Skinny_2_20120629000727578 | 01:08:00
Europe_UK_i BHX Sept O27_20120629051953770 | 06:20:00
Europe_UK_i BST Sept O26_20120629052110129 | 06:25:00 | 06:37:00
Europe_UK_i EDI Sept O31_20120629045332416 | 05:54:00
Europe_UK_i LCN Sept O27_20120629054221867 | 06:42:00
Europe_UK_i LGW Sept O31_20120629043759095 | 05:38:00
Europe_UK_i LHR Sept O30_20120629040950614 | 05:10:00 | 05:22:00
Europe_UK_i LTO Sept O28_20120629050926674 | 06:09:00
Europe_UK_i MAN Sept O26_20120629053143936 | 06:32:00 | 06:37:00
Europe_UK_i SMS Sept O31_20120629045903112 | 05:59:00
Europe_UK_d BHX Emulation 1st Jul31_20120629075304536 | 08:56:00
Europe_UK_d BHX Emulation 1st Sept o31_20120629081224769 | 09:17:00
Europe_UK_d EDI Emulation 1st Jul31_20120629074554400 | 08:46:00
Europe_UK_d EDI Emulation 1st Sept o31_20120629080657355 | 09:12:00
Europe_UK_d GLA Emulation 1st Jul30_20120629080006235 | 09:01:00
Europe_UK_d GLA Emulation 1st Sept o30_20120629081229613 | 09:17:00
Europe_UK_d LCN Emulation 1st Jul27_20120629080107174 | 09:01:00
Europe_UK_d LCY Emulation 1st Jul28_20120629080025813 | 09:01:00
Europe_UK_d LGW Emulation 1st Jul32_20120629074605885 | 08:51:00
Europe_UK_d LGW Emulation 1st Sept o36_20120629080702417 | 09:12:00
Europe_UK_d LHR Emulation 1st Jul30_20120629074610729 | 08:51:00
Europe_UK_d LHR Emulation 1st Sept o30_20120629080128206 | 09:01:00
Europe_UK_d LTN Emulation 1st Jul26_20120629080045048 | 09:02:00
Europe_UK_d MAN Emulation 1st Jul29_20120629080055642 | 09:02:00
Europe_UK_d SMS Emulation 1st Jul29_20120629075309693 | 08:56:00
Europe_UK_d SMS Emulation 1st Sept o29_20120629080707542 | 09:12:00
Europe_IT_i CIA 83_20120629042043443 | 05:25:00 | 05:36:00
Europe_IT_i TSF 83_20120629041522545 | 05:20:00 | 05:21:00
Europe_FR_i CDG Emulation Sum44_20120629040431559 | 05:04:00 | 05:21:00
Europe_FR_i CDG Emulation Sum45_20120629041509372 | 05:15:00 | 05:21:00
Europe_FR_i MRS Emulation Sum54_20120629035334964 | 04:54:00 | 05:07:00
Europe_FR_i MRS Emulation Sum55_20120629043210758 | 05:33:00 | 05:52:00
Europe_FR_i NCE Emulation Sum56_20120629031209869 | 04:12:00 | 04:21:00
Europe_ES_i ALL SP 79_20120629070924813 | 08:09:00