Spreadsheet: 162716d1340037655-automatic-data-sorting-itneraryextracta
Sheet: SORTED DATA

PORT | CALL TYPE | [NAME] |  | Departure |  |  | Hours in port | Hours at sea
at sea |  | 2010-03-01 00:00:00 | 00:00:00 | 2010-03-01 00:00:00 | 08:00:00
Yorkeys [NAME] | TR | 2010-03-01 00:00:00 | 08:00:00 | 2010-03-01 00:00:00 | 18:00:00
at sea |  | 2010-03-01 00:00:00 | 18:00:00 | 2010-03-02 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-02 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-03 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-04 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-05 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-06 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-07 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-08 00:00:00 | 00:00:00 |  | 08:00:00
[NAME] |  | 2010-03-08 00:00:00 | 08:00:00 |  | 18:00:00
at sea |  | 2010-03-08 00:00:00 | 18:00:00 | 2010-03-09 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-09 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-10 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-11 00:00:00 | 00:00:00 |  | 08:00:00
Hong Kong | ON | 2010-03-11 00:00:00 | 08:00:00 | 2010-03-12 00:00:00 | 1900-01-01 00:00:00
Hong Kong |  | 2010-03-12 00:00:00 | 00:00:00 |  | 21:00:00
at sea |  | 2010-03-12 00:00:00 | 21:00:00 | 2010-03-13 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-13 00:00:00 | 00:00:00 | 2010-03-14 00:00:00 | 23:59:00
at sea |  | 2010-03-14 00:00:00 | 00:00:00 |  | 08:00:00
[NAME] | PT | 2010-03-14 00:00:00 | 08:00:00 |  | 18:00:00
at sea |  | 2010-03-14 00:00:00 | 18:00:00 | 2010-03-15 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-15 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-16 00:00:00 | 00:00:00 |  | 06:00:00
[NAME] | TR | 2010-03-16 00:00:00 | 06:00:00 |  | 17:00:00
at sea |  | 2010-03-16 00:00:00 | 17:00:00 | 2010-03-17 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-17 00:00:00 | 00:00:00 |  | 07:00:00
[NAME] |  | 2010-03-17 00:00:00 | 07:00:00 |  | 19:00:00
at sea |  | 2010-03-17 00:00:00 | 19:00:00 | 2010-03-18 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-18 00:00:00 | 00:00:00 |  | 09:00:00
[NAME] | TR | 2010-03-18 00:00:00 | 09:00:00 |  | 17:00:00
at sea |  | 2010-03-18 00:00:00 | 17:00:00 | 2010-03-19 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-19 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-20 00:00:00 | 00:00:00 |  | 08:00:00
Singapore |  | 2010-03-20 00:00:00 | 08:00:00 |  | 19:00:00
at sea |  | 2010-03-20 00:00:00 | 19:00:00 | 2010-03-21 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-21 00:00:00 | 00:00:00 |  | 08:00:00
Port Kelang |  | 2010-03-21 00:00:00 | 08:00:00 |  | 19:00:00
at sea |  | 2010-03-21 00:00:00 | 19:00:00 | 2010-03-22 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-22 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-23 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-24 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-25 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-26 00:00:00 | 00:00:00 |  | 08:00:00
Mumbai |  | 2010-03-26 00:00:00 | 08:00:00 |  | 18:00:00
at sea |  | 2010-03-26 00:00:00 | 18:00:00 | 2010-03-27 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-27 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-28 00:00:00 | 00:00:00 |  | 09:00:00
Muscat | PT | 2010-03-28 00:00:00 | 09:00:00 |  | 17:00:00
at sea |  | 2010-03-28 00:00:00 | 17:00:00 | 2010-03-29 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-29 00:00:00 | 00:00:00 |  | 09:00:00
Dubai |  | 2010-03-29 00:00:00 | 09:00:00 |  | 18:00:00
at sea |  | 2010-03-29 00:00:00 | 18:00:00 | 2010-03-30 00:00:00 | 1900-01-01 00:00:00
at sea |  | 2010-03-30 00:00:00 | 00:00:00 |  | 23:59:00
at sea |  | 2010-03-31 00:00:00 | 00:00:00 |  | 23:59:00
 |  |  |  |  |  |  | Total Hours: |  | <-- Should equal the number of hours in March which is 744 - close enough