Spreadsheet: 94643d1294401096-splitting-out-a-hh-mm-ss-time-format-test
Sheet: test

Ticket | Start date | Reopened | Duration | On hold | SLA | Subject | Department | Priority | From | Assigned to
11562 | 2011-01-07 00:00:00 | NA | 0D 0H 57M | 0D 0H 0M | 0D 0H 57M | Trams | IT Support | P3 | Bravery, Pam | [NAME]
11555 | 2011-01-06 00:00:00 | NA | 0D 5H 11M | 0D 0H 0M | 0D 5H 11M | Remote Travelink Access | Selling Systems | P3 | [NAME] | [NAME]
11554 | 2011-01-06 00:00:00 | NA | 0D 5H 26M | 0D 0H 0M | 0D 5H 26M | ECSQ Changes on the Brand Websites | IT Support | P3 | Harvey, [NAME] | [NAME]
11553 | 2011-01-06 00:00:00 | NA | 0D 5H 26M | 0D 0H 0M | 0D 5H 26M | BlackBerry | IT Support | P3 | [NAME], [NAME] | [NAME]
11552 | 2011-01-06 00:00:00 | NA | 0D 6H 18M | 0D 0H 0M | 0D 6H 18M | FW: VPN Access | IT Support | P3 | Smith, [NAME] | [NAME]
11549 | 2011-01-06 00:00:00 | NA | 0D 6H 45M | 0D 0H 0M | 0D 6H 45M | FW: Aftersales | IT Support | P3 | East, [NAME] | Kev East
11544 | 2011-01-06 00:00:00 | NA | 0D 7H 53M | 0D 0H 0M | 0D 7H 53M | FW: [#519296] (Response) LH FEEDBACK ... | IT Support | P3 | Clapton, [NAME] | [NAME]
11542 | 2011-01-06 00:00:00 | NA | 0D 8H 51M | 0D 0H 0M | 0D 8H 51M | Amadeus API | IT Support | P3 | Byron, [NAME] | [NAME]
11541 | 2011-01-06 00:00:00 | NA | 0D 9H 15M | 0D 0H 0M | 0D 9H 15M | RE: [#11898] (Response) outlook issues ... | IT Support | P3 | [NAME], [NAME] | [NAME]
11540 | 2011-01-06 00:00:00 | NA | 0D 9H 21M | 0D 0H 0M | 0D 9H 21M | RE: Ticket #11848 Assigned to you | IT Support | P3 | Bravery, [NAME] | Marcus Culver
11533 | 2011-01-06 00:00:00 | NA | 1D 2H 27M | 0D 0H 0M | 1D 2H 27M | RE: [#11847] (Response) Acess to ... | IT Support | P3 | Hufton, [NAME] | [NAME]
11527 | 2011-01-05 00:00:00 | NA | 0D 4H 42M | 0D 0H 0M | 0D 4H 42M | FW: DFS Mapping Change for [NAME] ... | IT Support | P3 | [NAME] | [NAME]
11526 | 2011-01-05 00:00:00 | NA | 0D 4H 55M | 0D 0H 0M | 0D 4H 55M | FW: Email an Itinerary not working on ... | IT Support | P3 | Mercer, Amber | [NAME]
11520 | 2011-01-05 00:00:00 | NA | 0D 7H 40M | 0D 0H 0M | 0D 7H 40M | Telephony | IT Support | P3 | [NAME] | Kev East
249881 | 2011-01-05 00:00:00 | NA | 0D 8H 11M | 0D 0H 0M | 0D 8H 11M | FW: file access mvincent done | IT Support | P3 | [NAME], [NAME] | [NAME]
959365 | 2010-12-29 00:00:00 | 2011-01-05 00:00:00 | 0D 8H 24M | 0D 0H 0M | 0D 8H 24M | Ella Hornall's Call Recordings | IT Support | P3 | Jones, [NAME] | [NAME]
972429 | 2011-01-05 00:00:00 | NA | 0D 8H 34M | 0D 0H 0M | 0D 8H 34M | Mobile | IT Support | P3 | Appleby, [NAME] | [NAME]
491300 | 2011-01-05 00:00:00 | NA | 0D 8H 47M | 0D 0H 0M | 0D 8H 47M | Folder Access for Sabine van Bergen | IT Support | P3 | Green, [NAME] | Kev East
841417 | 2011-01-05 00:00:00 | NA | 1D 0H 9M | 0D 0H 0M | 1D 0H 9M | [NAME] | IT Support | P3 | [NAME], Georgina | [NAME]
596439 | 2011-01-05 00:00:00 | NA | 1D 0H 58M | 0D 0H 0M | 1D 0H 58M | Re: [#11388] (Response) MAIL NOT ... | IT Support | P3 | [NAME], [NAME] | [NAME]
944537 | 2011-01-05 00:00:00 | NA | 1D 1H 16M | 0D 0H 0M | 1D 1H 16M | FW:Trying to Print out Newsflash - ... | IT Support | P3 | [NAME] | [NAME]
155111 | 2011-01-05 00:00:00 | NA | 1D 1H 16M | 0D 0H 0M | 1D 1H 16M | FW: Keyboard has incorrect settings | IT Support | P3 | [NAME] | [NAME]
595084 | 2011-01-04 00:00:00 | NA | 0D 3H 32M | 0D 0H 0M | 0D 3H 32M | FW: Actions from Conference Call | IT Support | P3 | Byron, [NAME] | [NAME]
847363 | 2011-01-04 00:00:00 | NA | 0D 5H 5M | 0D 0H 0M | 0D 5H 5M | MCS ACCESS | IT Support | P3 | Wason, [NAME] | [NAME]
967781 | 2011-01-04 00:00:00 | NA | 0D 5H 32M | 0D 0H 0M | 0D 5H 32M | FW: IBE Upgrade | IT Support | P3 | Byron, [NAME] | [NAME]
294103 | 2011-01-04 00:00:00 | NA | 0D 9H 17M | 0D 0H 0M | 0D 9H 17M | RE: [#11862] (Response) LH Groups lines ... | IT Support | P3 | Emerre, [NAME] | [NAME]
300052 | 2011-01-04 00:00:00 | NA | 1D 0H 27M | 0D 0H 0M | 1D 0H 27M | RE: [#11440] (Response) amadeus | IT Support | P3 | Capelin, [NAME] | [NAME]
381887 | 2011-01-04 00:00:00 | NA | 1D 1H 32M | 0D 0H 0M | 1D 1H 32M | FW: Latest Exchange rate log | IT Support | P3 | Mercer, Amber | Kev East
103490 | 2011-01-04 00:00:00 | NA | 1D 1H 43M | 0D 0H 0M | 1D 1H 43M | Calls going through to duty office | IT Support | P3 | [NAME] | Kev East
713958 | 2011-01-04 00:00:00 | NA | 1D 2H 16M | 0D 0H 0M | 1D 2H 16M | Headsets | IT Support | P3 | [NAME], [NAME] | Kev East
888154 | 2011-01-03 00:00:00 | NA | 2D 7H 2M | 0D 0H 0M | 2D 7H 2M | FW: Brochure Ordering | Selling Systems | P3 | Mercer, Amber | [NAME]
370748 | 2011-01-03 00:00:00 | NA | 2D 7H 2M | 0D 0H 0M | 2D 7H 2M | FW: Ella Hornall's Call Recordings | IT Support | P3 | Jones, [NAME] | [NAME]
513049 | 2010-12-31 00:00:00 | NA | 3D 8H 39M | 0D 0H 0M | 3D 8H 39M | Verint E-quality | IT Support | P3 | [NAME] | [NAME]
744587 | 2010-12-30 00:00:00 | NA | 4D 7H 35M | 0D 0H 0M | 4D 7H 35M | infant flight prices | Selling Systems | P3 | Greasley, [NAME] | [NAME]
529848 | 2010-12-30 00:00:00 | NA | 4D 8H 0M | 0D 0H 0M | 4D 8H 0M | Direct Line | IT Support | P3 | Appleby, [NAME] | Kev East
294628 | 2010-12-29 00:00:00 | NA | 5D 6H 11M | 0D 0H 0M | 5D 6H 11M | General support | IT Support | P3 | laurent ferros | Marcus Culver
640756 | 2010-12-23 00:00:00 | NA | 9D 6H 20M | 0D 0H 0M | 9D 6H 20M | Telephone | IT Support | P3 | Betchley, Zoe | Kev East
11548 | 2011-01-06 00:00:00 | NA | 0D 6H 49M | 0D 0H 0M | 0D 6H 49M | New printers | IT Support | P4 | [NAME] | Kev East
11524 | 2011-01-05 00:00:00 | NA | 0D 6H 27M | 0D 0H 0M | 0D 6H 27M | Error when running report in crisys | Selling Systems | P4 | [NAME] | [NAME]
222177 | 2010-12-22 00:00:00 | NA | 10D 9H 5M | 5D 2H 15M | 5D 6H 50M | Wallboards | IT Support | P4 | [NAME], [NAME] | [NAME]