Spreadsheet: 270656d1381576774-conditional-format-a-table-border-base-on-groups-of-any-text-in-a-column-book1
Sheet: sample for forum

Title
Title cont…
DATE | BOOKING | TASK | No/of people on job | TOTAL TASK HOURS HRS/MIN | TOTAL DAILY HOURS HRS/MIN | EXPENSE  ITEMS | RATE     $ | EXPENSE  $ | SERVICE $ | SERVICE + EXPENSES  $ | NOTES
2013-08-20 00:00:00 |  | Cleaned units 1-8/
2013-08-20 00:00:00 |  | Sorted linen | 1 | 5:30:00
2013-08-21 00:00:00 |  | Cleaned toilet blocks | 1
2013-08-21 00:00:00 |  | Sorted linen | 1
2013-08-21 00:00:00 |  | Cleaned West Cottage | 1 | 4:00:00
2013-08-22 00:00:00 |  | Spring cleaned west Cottage and Kitchen floors | 1 | 5:00:00
2013-08-27 00:00:00 |  | Cleaned oven in West Cottage | 1 | 4:00:00 |  | Oven cleaners, scourers etc. |  | 10
2013-08-30 00:00:00 |  | Mopped hall, Set units 1-5  for guests, General tidy up | 1 | 3:00:00
2013-08-30 00:00:00 | [NAME]
2013-09-01 00:00:00 | Jones Dept
2013-09-02 00:00:00 |  | Stripped and cleaned Units 1 - 4 + 8 | 1 | 2:30:00
2013-09-10 00:00:00 |  | Made beds,vac & mop Units 1-4 & 8
2013-09-10 00:00:00 |  | Set up units 1-8 & West cottage with supplies
2013-09-10 00:00:00 |  | Cleaned boys & girls toilet blocks
2013-09-10 00:00:00 |  | Cleaned hall
2013-09-10 00:00:00 |  | Mopped kitchen floors
2013-09-10 00:00:00 |  | Cleaned cooks quarters
2013-09-10 00:00:00 |  | Sorted and put away linen | 1 | 7:00:00
2013-09-13 00:00:00 | Retreat Arrived
2013-09-15 00:00:00 | Retreat Dept
2013-09-19 00:00:00 |  | Hosed out amenities block-thorough clean |  |  | 4hrs x 2
2013-09-19 00:00:00 |  | fix sealing in boys amenities
2013-09-19 00:00:00 |  | Stripped & cleaned  Units 1 - 8
2013-09-19 00:00:00 |  | Stripped west cottage |  |  | 4.5hrsx2
2013-09-19 00:00:00 |  | Fixed skylight in unit 2, fixed wiring in lights in 3 units, replaced several light globes | 2 | 4:00:00
2013-09-20 00:00:00 |  | Made beds in units 1-8
2013-09-20 00:00:00 |  | [NAME] and mopped floors in 1-4
2013-09-20 00:00:00 |  | Set up units 1-4
2013-09-20 00:00:00 |  | Cleaned and Set up West Cottage
2013-09-20 00:00:00 |  | Cleaned cooks quarters | 2 | 4:30:00
2013-09-21 00:00:00 | booking arrived
2013-09-22 00:00:00 | booking arrived
2013-09-22 00:00:00 | booking dept
2013-09-22 00:00:00 |  | Cleaned, mop, vac & made beds in units 1 & 2
2013-09-22 00:00:00 |  | Cleaned,vac,mop, made beds in West cotage
2013-09-22 00:00:00 |  | Set up units 1-4&west cottage
2013-09-22 00:00:00 |  | fixed lock in boy amenities
2013-09-22 00:00:00 |  | Vac & mopped both amenities
2013-09-22 00:00:00 |  | sorted and put away linen | 2 | 3:15:00
2013-09-24 00:00:00 | booking dept
2013-09-24 00:00:00 |  | Cleaned, [NAME],mop, made beds Units 1-4 &West
2013-09-24 00:00:00 |  | Stripped and cleaned Units 5&7
2013-09-24 00:00:00 |  | Cleaned Unit 6
2013-09-24 00:00:00 |  | Set Up Units 1-4 & West Cottage
2013-09-24 00:00:00 |  | Vac & mopped both amenities
2013-09-24 00:00:00 |  | Fixed 2x cisterns in boys amenities:Leaking | 2 | 4:00:00
2013-09-25 00:00:00 | x arrived
2013-09-25 00:00:00 |  | Made beds, vac, mop & set up units 5 - 8 & west cottage | 1 | 3:30:00
2013-09-28 00:00:00 | x dept
2013-09-29 00:00:00 |  | Stripped & cleaned  Units 1,2 & west cottage | 1 | 2:00:00
2013-09-29 00:00:00
TOTAL