Spreadsheet: 119457d1314410648-condense-rows-based-on-alphabetic-value-display-max-and-min-values-in-other-columns-fahall_test
Sheet: Sheet1

Week Comencing | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
 | 2011-08-28 00:00:00 |  |  | 2011-08-29 00:00:00 |  |  | 2011-08-30 00:00:00 |  |  | 2011-08-31 00:00:00 |  |  | 2011-09-01 00:00:00 |  |  | 2011-09-02 00:00:00 |  |  | 2011-09-03 00:00:00
FIRST | Start | Finish | Hrs | Start | Finish | Hrs | Start | Finish | Hrs | Start | Finish | Hrs | Start | Finish | Hrs | Start | Finish | Hrs | Start | Finish | Hrs | Hours |  | Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min | [NAME]
[NAME] |  |  | 0 |  |  | 0 | 15:00:00 | 15:30:00 | 0.5000000000000009 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0.5000000000000009 |  | Task 9 |  |  |  |  |  |  |  | 15:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00
[NAME] |  |  | 0 |  |  | 0 | 15:30:00 | 20:00:00 | 4.5 | 15:00:00 | 20:00:00 | 5.000000000000001 | 15:00:00 | 19:00:00 | 3.999999999999999 | 15:00:00 | 20:00:00 | 5.000000000000001 | 12:00:00 | 20:00:00 | 8 | 18.5 |  | Task 8 |  |  |  |  |  |  |  | 15:30:00 | 20:00:00 |  | 15:00:00 | 20:00:00 |  | 15:00:00 | 19:00:00 |  | 15:00:00 | 20:00:00 |  | 12:00:00 | 20:00:00 |  |  | 12:00:00 | 20:00:00
[NAME] |  |  | 0 |  |  | 0 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 | 19:00:00 | 23:00:00 | 4.000000000000002 | 20:00:00 | 23:00:00 | 3 |  |  | 0 | 13 |  | Task 2 |  |  |  |  |  |  |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  | 19:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  |  |  |  |  | 19:00:00 | 23:00:00
[NAME] | 12:00:00 | 20:00:00 | 8 |  |  | 0 |  |  | 0 | 20:00:00 | 23:00:00 | 3 |  |  | 0 |  |  | 0 |  |  | 0 | 11 |  | Task 5 |  | 12:00:00 | 20:00:00 |  |  |  |  |  |  |  | 20:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 23:00:00
[NAME] |  |  | 0 |  |  | 0 | 16:00:00 | 23:00:00 | 7.000000000000002 | 16:00:00 | 20:00:00 | 4.000000000000002 |  |  | 0 |  |  | 0 |  |  | 0 | 11 |  | Task 4 |  |  |  |  |  |  |  | 16:00:00 | 23:00:00 |  | 16:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 23:00:00
[NAME] | 12:00:00 | 21:00:00 | 9 |  |  | 0 | 07:45:00 | 15:00:00 | 7.25 | 14:00:00 | 22:30:00 | 8.5 | 07:45:00 | 15:00:00 | 7.25 | 15:00:00 | 23:30:00 | 8.5 |  |  | 0 | 40.5 |  | Task 4 |  | 12:00:00 | 21:00:00 |  |  |  |  | 07:45:00 | 15:00:00 |  | 14:00:00 | 22:30:00 |  | 07:45:00 | 15:00:00 |  | 15:00:00 | 23:30:00 |  |  |  |  |  | 07:45:00 | 23:30:00
[NAME] |  |  | 0 |  |  | 0 | 15:00:00 | 15:30:00 | 0.5000000000000009 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0.5000000000000009 |  | Task 9 |  |  |  |  |  |  |  | 15:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 | 15:00:00 | 15:30:00 | 0.5000000000000009 |  |  | 0 |  |  | 0 |  |  | 0 | 0.5000000000000009 |  | Task 9 |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 | 15:30:00 | 18:30:00 | 3 |  |  | 0 |  |  | 0 |  |  | 0 | 3 |  | Task 7 |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 18:30:00
[NAME] |  |  | 0 | 14:30:00 | 19:00:00 | 4.5 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 4.5 |  | Task 6 |  |  |  |  | 14:30:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | 19:00:00
[NAME] |  |  | 0 | 19:00:00 | 22:00:00 | 3 |  |  | 0 |  |  | 0 | 15:00:00 | 23:00:00 | 8 | 15:00:00 | 23:00:00 | 8 | 12:30:00 | 20:30:00 | 7.999999999999998 | 19 |  | Task 8 |  |  |  |  | 19:00:00 | 22:00:00 |  |  |  |  |  |  |  | 15:00:00 | 23:00:00 |  | 15:00:00 | 23:00:00 |  | 12:30:00 | 20:30:00 |  |  | 12:30:00 | 23:00:00
Elvis |  |  | 0 |  |  | 0 | 18:00:00 | 20:00:00 | 2.000000000000001 | 17:00:00 | 20:00:00 | 3 |  |  | 0 | 15:00:00 | 20:00:00 | 5.000000000000001 | 12:00:00 | 21:00:00 | 9 | 10 |  | Task 4 |  |  |  |  |  |  |  | 18:00:00 | 20:00:00 |  | 17:00:00 | 20:00:00 |  |  |  |  | 15:00:00 | 20:00:00 |  | 12:00:00 | 21:00:00 |  |  | 12:00:00 | 21:00:00
Elvis |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 18:00:00 | 20:00:00 | 2.000000000000001 |  |  | 0 |  |  | 0 | 2.000000000000001 |  | Task 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | 18:00:00 | 20:00:00
Elvis |  |  | 0 |  |  | 0 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 |  |  | 0 | 12 |  | Task 2 |  |  |  |  |  |  |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  |  |  |  |  | 20:00:00 | 23:00:00
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 | 23:00:00 | 23:30:00 | 0.4999999999999982 | 23:00:00 | 23:30:00 | 0.4999999999999982 | 23:00:00 | 23:30:00 | 0.4999999999999982 |  |  | 0 | 1.499999999999995 |  | Task 4 |  |  |  |  |  |  |  |  |  |  | 23:00:00 | 23:30:00 |  | 23:00:00 | 23:30:00 |  | 23:00:00 | 23:30:00 |  |  |  |  |  | 23:00:00 | 23:30:00
[NAME] |  |  | 0 |  |  | 0 | 15:00:00 | 15:30:00 | 0.5000000000000009 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0.5000000000000009 |  | Task 9 |  |  |  |  |  |  |  | 15:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 15:30:00
[NAME] |  |  | 0 |  |  | 0 |  |  | 0 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 | 20:00:00 | 23:00:00 | 3 |  |  | 0 | 9 |  | Task 3 |  |  |  |  |  |  |  |  |  |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  | 20:00:00 | 23:00:00 |  |  |  |  |  | 20:00:00 | 23:00:00
[NAME] |  |  | 0 | 15:00:00 | 23:30:00 | 8.5 | 15:00:00 | 23:30:00 | 8.5 | 15:00:00 | 20:00:00 | 5.000000000000001 | 15:00:00 | 20:00:00 | 5.000000000000001 | 15:00:00 | 20:00:00 | 5.000000000000001 |  |  | 0 | 32 |  | Task 4 |  |  |  |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 23:30:00 |  | 15:00:00 | 20:00:00 |  | 15:00:00 | 20:00:00 |  | 15:00:00 | 20:00:00 |  |  |  |  |  | 15:00:00 | 23:30:00