Spreadsheet: 187264d1350394317-minimum-maximum-dates-times-if-function-parenethesis-andy-progress
Sheet: A.Manning

Type | RefId | House | [NAME] | Departure Time | Time on Site |  | Day of Month | Jobs per day | Start Time | Finish time |  | Length of day
Maintenance | 106-81986 | COPPERFIELDS | 01/09/2012 10:15 | 01/09/2012 11:00 | 00:45:00 |  | 01
Maintenance | 32-81977 | O'Neills - Bromley | 01/09/2012 11:50 | 01/09/2012 12:15 | 00:25:00 |  | 02
Maintenance | 58-81923 | Sutton & Epsom RFC | 01/09/2012 13:30 | 01/09/2012 13:55 | 00:25:00 |  | 03
Maintenance | 125-82021 | RAILWAY HOTEL | 01/09/2012 14:30 | 01/09/2012 14:50 | 00:20:00 |  | 04
Maintenance | 125-82020 | [NAME] | 01/09/2012 15:40 | 01/09/2012 16:20 | 00:40:00 |  | 05
Maintenance | 152-82023 | Golden Leas Holiday Park | 01/09/2012 17:25 | 01/09/2012 17:55 | 00:30:00 |  | 06
Maintenance | 58-82043 | [NAME] | 03/09/2012 13:15 | 03/09/2012 13:30 | 00:15:00 |  | 07
Maintenance | 58-82065 | Horsmonden Sports Cub | 03/09/2012 16:00 | 03/09/2012 16:25 | 00:25:00 |  | 08
Maintenance | 114-82088 | HARVESTER RUNNING HORSE | 03/09/2012 17:10 | 03/09/2012 17:40 | 00:30:00 |  | 09
Maintenance | 125-82076 | Yacht | 03/09/2012 18:20 | 03/09/2012 18:40 | 00:20:00 |  | 10
Maintenance | 132-82067 | LION | 03/09/2012 19:20 | 03/09/2012 19:55 | 00:35:00 |  | 11
Maintenance | 125-82105 | Lordswood Tenpin Bowling | 03/09/2012 20:30 | 03/09/2012 21:00 | 00:30:00 |  | 12
Maintenance | 42-82124 | TRAVELLERS HOME | 04/09/2012 15:05 | 04/09/2012 15:25 | 00:20:00 |  | 13
Install | 31-81199 | [NAME] | 04/09/2012 15:40 | 04/09/2012 15:55 | 00:15:00 |  | 14
Maintenance | 132-82158 | [NAME] | 04/09/2012 16:00 | 04/09/2012 16:30 | 00:30:00 |  | 15
Maintenance | 132-82136 | LORD KITCHENER | 04/09/2012 17:00 | 04/09/2012 17:30 | 00:30:00 |  | 16
Maintenance | 125-82107 | LION | 04/09/2012 18:15 | 04/09/2012 19:15 | 01:00:00 |  | 17
Maintenance | 125-82156 | Nevill Gold Club | 04/09/2012 19:45 | 04/09/2012 20:15 | 00:30:00 |  | 18
Maintenance | 58-82188 | [NAME] | 05/09/2012 14:20 | 05/09/2012 15:10 | 00:50:00 |  | 19
Maintenance | 58-82189 | [NAME] | 05/09/2012 16:00 | 05/09/2012 16:15 | 00:15:00 |  | 20
Maintenance | 58-82187 | [NAME] | 05/09/2012 17:50 | 05/09/2012 18:30 | 00:40:00 |  | 21
Maintenance | 132-82206 | LION | 05/09/2012 19:25 | 05/09/2012 20:10 | 00:45:00 |  | 22
Maintenance | 114-82257 | [NAME] | 06/09/2012 12:35 | 06/09/2012 13:40 | 01:05:00 |  | 23
Maintenance | 114-82295 | BLACK HORSE | 06/09/2012 17:30 | 06/09/2012 18:00 | 00:30:00 |  | 24
Install | 42-82214 | Giraffe | 07/09/2012 10:00 | 07/09/2012 15:30 | 05:30:00 |  | 25
Maintenance | 157-82300 | [NAME] | 07/09/2012 18:00 | 07/09/2012 18:15 | 00:15:00 |  | 26
Maintenance | 125-82357 | Lost Hour (prev Auctioneer) | 07/09/2012 19:30 | 07/09/2012 20:00 | 00:30:00 |  | 27
Maintenance | 32-82267 | [NAME] | 07/09/2012 20:30 | 07/09/2012 21:00 | 00:30:00 |  | 28
Maintenance | 106-82445 | [NAME] | 10/09/2012 14:40 | 10/09/2012 15:40 | 01:00:00 |  | 29
Maintenance | 58-82528 | House on the Hill | 11/09/2012 13:15 | 11/09/2012 13:55 | 00:40:00 |  | 30
Maintenance | 106-82537 | DAYLIGHT INN | 11/09/2012 14:30 | 11/09/2012 14:50 | 00:20:00 |  | 31
Maintenance | 58-82506 | Foresters Arms | 11/09/2012 16:30 | 11/09/2012 17:15 | 00:45:00
Maintenance | 114-82590 | O'Neills - Beckenham | 11/09/2012 19:10 | 11/09/2012 19:30 | 00:20:00
Maintenance | 58-82625 | OLD PLOUGH | 12/09/2012 15:00 | 12/09/2012 15:30 | 00:30:00
Maintenance | 106-82606 | Miller & Carter Lancing | 12/09/2012 16:30 | 12/09/2012 17:00 | 00:30:00
Maintenance | 58-82517 | [NAME] | 12/09/2012 19:10 | 12/09/2012 19:25 | 00:15:00
Maintenance | 132-82626 | HARVESTER HAWTH PARK INN | 12/09/2012 20:35 | 12/09/2012 20:55 | 00:20:00
Maintenance | 132-82631 | FLIGHT TAVERN | 13/09/2012 14:45 | 13/09/2012 16:15 | 01:30:00
Maintenance | 132-82738 | Beehive | 13/09/2012 16:30 | 13/09/2012 17:00 | 00:30:00
Maintenance | 106-82647 | Mesmerist | 13/09/2012 18:00 | 13/09/2012 18:30 | 00:30:00
Maintenance | 125-82752 | WHITE RABBIT | 13/09/2012 20:15 | 13/09/2012 20:35 | 00:20:00
Maintenance | 58-82765 | Slug & Lettuce | 14/09/2012 15:00 | 14/09/2012 15:30 | 00:30:00
Maintenance | 58-81881 | White Lyon & Dragon | 14/09/2012 16:15 | 14/09/2012 17:00 | 00:45:00
Maintenance | 132-82786 | HARVESTER TALMEAD | 14/09/2012 19:15 | 14/09/2012 19:20 | 00:05:00
Maintenance | 157-82808 | OLD PLOUGH | 15/09/2012 12:00 | 15/09/2012 13:00 | 01:00:00
Maintenance | 125-82820 | OLD PLOUGH | 15/09/2012 13:30 | 15/09/2012 14:10 | 00:40:00
Maintenance | 125-82813 | GRENADIER | 15/09/2012 14:45 | 15/09/2012 15:15 | 00:30:00
Maintenance | 157-82806 | [NAME] | 15/09/2012 15:40 | 15/09/2012 15:55 | 00:15:00
Maintenance | 157-82839 | [NAME] (White Hart) | 17/09/2012 08:40 | 17/09/2012 09:30 | 00:50:00
Maintenance | 157-82841 | OLD BANK | 17/09/2012 11:15 | 17/09/2012 12:30 | 01:15:00
Maintenance | 42-82863 | [NAME] | 17/09/2012 13:40 | 17/09/2012 14:00 | 00:20:00
Maintenance | 114-82880 | HARVESTER HORSE & GROOM | 17/09/2012 14:45 | 17/09/2012 15:15 | 00:30:00
Maintenance | 58-82842 | THREE BLACKBIRDS | 17/09/2012 15:35 | 17/09/2012 15:55 | 00:20:00
Maintenance | 114-82866 | HARVESTER RISING SUN | 17/09/2012 16:20 | 17/09/2012 16:40 | 00:20:00
Maintenance | 125-82882 | Stand Up Inn | 18/09/2012 10:20 | 18/09/2012 11:50 | 01:30:00
Maintenance | 31-82923 | [NAME] | 18/09/2012 14:40 | 18/09/2012 15:00 | 00:20:00
Maintenance | 132-82941 | COPPERFIELDS | 18/09/2012 16:00 | 18/09/2012 16:30 | 00:30:00
Maintenance | 106-82920 | O'Neills | 19/09/2012 10:15 | 19/09/2012 10:40 | 00:25:00
Maintenance | 106-82936 | ROYAL PAVILION TAVERN | 19/09/2012 12:25 | 19/09/2012 12:45 | 00:20:00
Maintenance | 132-83051 | NORTH STAR | 19/09/2012 13:30 | 19/09/2012 13:45 | 00:15:00
Maintenance | 106-83055 | PEACEHAVEN | 19/09/2012 14:40 | 19/09/2012 14:55 | 00:15:00
Maintenance | 114-83077 | [NAME]Prev Fox & Hounds) | 19/09/2012 16:20 | 19/09/2012 16:45 | 00:25:00
Maintenance | 157-83091 | RAILWAY | 20/09/2012 10:15 | 20/09/2012 11:00 | 00:45:00
Maintenance | 132-83117 | WHITE RABBIT | 20/09/2012 12:10 | 20/09/2012 13:00 | 00:50:00
Maintenance | 125-83133 | [NAME] | 20/09/2012 15:45 | 20/09/2012 16:15 | 00:30:00
Maintenance | 125-83169 | [NAME] | 21/09/2012 09:40 | 21/09/2012 10:30 | 00:50:00
Maintenance | 132-83164 | HARVESTER HORSE & GROOM | 21/09/2012 11:00 | 21/09/2012 11:45 | 00:45:00
Maintenance | 132-83142 | TOBY CARVERY BEXLEY HEATH | 21/09/2012 12:25 | 21/09/2012 12:35 | 00:10:00
Maintenance | 42-83193 | WHITE RABBIT | 21/09/2012 13:10 | 21/09/2012 13:30 | 00:20:00
Maintenance | 114-83157 | [NAME] (White Hart) | 21/09/2012 14:00 | 21/09/2012 14:45 | 00:45:00
Maintenance | 45-83203 | South East Coachworks | 21/09/2012 16:00 | 21/09/2012 17:15 | 01:15:00
Holiday | 60-83033 | Holiday - Engineers | 24/09/2012 09:00 | 25/09/2012 17:00 | 1900-01-01 08:00:00
Install | 42-81976 | Miller & Carter Bexley(Jacobean Barn) | 26/09/2012 07:45 | [NAME] 16:30 | 08:45:00
Maintenance | 42-83492 | PARK VIEW | 27/09/2012 11:35 | 27/09/2012 12:00 | 00:25:00
Maintenance | 132-83503 | Waggon & Horses | 27/09/2012 12:30 | 27/09/2012 12:45 | 00:15:00
Maintenance | 114-83443 | TOBY CARVERY WILLINGDON DROVE | 27/09/2012 13:40 | 27/09/2012 13:50 | 00:10:00
Maintenance | 157-83403 | Kerrys Bar | 27/09/2012 14:45 | 27/09/2012 14:55 | 00:10:00
Maintenance | 157-83401 | Bull Inn & Wine Bar | 27/09/2012 15:25 | 27/09/2012 16:00 | 00:35:00
Maintenance | 125-83558 | Zingara | 27/09/2012 18:30 | 27/09/2012 19:15 | 00:45:00
Maintenance | 32-83480 | COPPERFIELDS | 27/09/2012 20:15 | 27/09/2012 20:35 | 00:20:00
Install | 31-79717 | Fox | 28/09/2012 10:00 | 28/09/2012 10:30 | 00:30:00
Maintenance | 157-83102 | Wheatsheaf | 28/09/2012 11:15 | 28/09/2012 12:15 | 01:00:00
Maintenance | 125-83485 | [NAME] | 28/09/2012 12:50 | 28/09/2012 13:10 | 00:20:00
Maintenance | 42-83537 | ARKLE MANOR | 28/09/2012 13:55 | 28/09/2012 14:30 | 00:35:00
Maintenance | 42-83618 | HARVESTER KATARINA | 28/09/2012 16:00 | 28/09/2012 16:55 | 00:55:00
Maintenance | 132-83591 | GRENADIER | 28/09/2012 17:30 | 28/09/2012 17:45 | 00:15:00
Maintenance | 132-83523 | ROYAL OAK | 29/09/2012 10:00 | 29/09/2012 10:40 | 00:40:00
Maintenance | 125-83486 | ELLIOTS WINE BAR | 29/09/2012 11:40 | 29/09/2012 12:00 | 00:20:00
Maintenance | 125-83632 | [NAME] | 29/09/2012 12:45 | 29/09/2012 13:05 | 00:20:00
Maintenance | 132-83633 | Miller & Carter Bexley(Jacobean Barn) | 29/09/2012 14:30 | 29/09/2012 15:00 | 00:30:00
Maintenance | 152-83664 | QUEENS HEAD | 29/09/2012 15:20 | 29/09/2012 15:40 | 00:20:00
Maintenance | 125-83672 | New Town Social Club | 29/09/2012 17:45 | 29/09/2012 18:30 | 00:45:00
 |  |  | Holiday
 |  |  | Installs
 |  |  | Maintenance
 |  |  | Wse's