Spreadsheet: 93478d1293042401-help-with-sum-only-if-meets-both-criteria-11-2010-ot-stats
Sheet: Sheet2

2010-11-01 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-01 00:00:00 | C1ATO | 08:30:00 | 09:00:00 | 0.4999999999999996 |  |  | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
2010-11-01 00:00:00 | C1ATO | 09:00:00 | 10:00:00 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2010-11-01 00:00:00 | C2 ATO | 09:00:00 | 10:00:00 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2010-11-01 00:00:00 | C2 ATO | 14:00:00 | 22:00:00 | 7.999999999999998 |  |  |  |  |  | 1 | 2 | 2 | 2 | 1 |  |  | 8
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5 | TOTAL HRS |  | 10.5
 |  |  |  |  |  | 0 | 0.5 | 2 | 0 | 1 | 2 | 2 | 2 | 1 | 0 | 10.5
2010-11-02 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-02 00:00:00 | C2 ATO | 13:30:00 | 18:30:00 | 5.000000000000001 |  |  |  |  |  | 1.5 | 2 | 2.5 |  |  |  |  | 6
2010-11-02 00:00:00 | C2 ATO | 17:00:00 | 19:00:00 | 1.999999999999998 |  |  |  |  |  |  |  | 2 |  |  |  |  | 2
2010-11-02 00:00:00 | C2 ATO | 20:00:00 | 20:30:00 | 0.4999999999999982 |  |  |  |  |  |  |  |  | 0.5 |  |  |  | 0.5
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | TOTAL HRS |  | 8.5
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1.5 | 2 | 4.5 | 0.5 | 0 | 0 | 8.5
2010-11-03 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-03 00:00:00 | [NAME] | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-03 00:00:00 | C1ATO | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-03 00:00:00 | C1ATO | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-03 00:00:00 | C3ATO | 09:00:00 | 10:00:00 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2010-11-03 00:00:00 | TERM A ATO | 10:00:00 | 14:00:00 | 4 |  |  |  | 1 | 2 | 1 |  |  |  |  |  |  | 4
2010-11-03 00:00:00 | TA | 15:30:00 | 17:30:00 | 1.999999999999998 |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  |  | 2
2010-11-03 00:00:00 | C1 | 16:00:00 | 17:30:00 | 1.5 |  |  |  |  |  |  | 1 | 0.5 |  |  |  |  | 1.5
2010-11-03 00:00:00 | TA | 16:30:00 | 19:30:00 | 3 |  |  |  |  |  |  | 0.5 | 2 | 0.5 |  |  |  | 3
2010-11-03 00:00:00 | TA | 17:00:00 | 18:00:00 | 0.9999999999999991 |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
2010-11-03 00:00:00 | C1 | 17:30:00 | 19:30:00 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-03 00:00:00 | TA | 18:00:00 | 18:30:00 | 0.5000000000000009 |  |  |  |  |  |  |  | 0.5 |  |  |  |  | 0.5
2010-11-03 00:00:00 | C1 | 20:00:00 | 22:00:00 | 1.999999999999998 |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 2
2010-11-03 00:00:00 | TA | 20:30:00 | 21:30:00 | 1.000000000000002 |  |  |  |  |  |  |  |  | 0.5 | 0.5 |  |  | 1
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5 | TOTAL HRS |  | 19.5
 |  |  |  |  |  | 0 | 0 | 3.5 | 2 | 1 | 3 | 6 | 2.5 | 1.5 | 0 | 19.5
2010-11-04 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-04 00:00:00 | TERM A ATO | 09:30:00 | 11:30:00 | 2.000000000000001 |  |  |  | 1.5 | 0.5 |  |  |  |  |  |  |  | 2
2010-11-04 00:00:00 | TERM A ATO | 09:30:00 | 12:00:00 | 2.5 |  |  |  | 1.5 | 1 |  |  |  |  |  |  |  | 2.5
2010-11-04 00:00:00 | C2 ATO | 14:00:00 | 16:00:00 | 1.999999999999998 |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 2
2010-11-04 00:00:00 | C2 ATO | 15:00:00 | 17:00:00 | 2.000000000000001 |  |  |  |  |  |  | 2 |  |  |  |  |  | 2
2010-11-04 00:00:00 | C2 ATO | 15:30:00 | 16:00:00 | 0.4999999999999982 |  |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.5
2010-11-04 00:00:00 | C2 ATO | 17:00:00 | 21:00:00 | 3.999999999999999 |  |  |  |  |  |  |  | 2 | 2 |  |  |  | 4
2010-11-04 00:00:00 | C2 ATO | 17:30:00 | 18:30:00 | 1.000000000000002 |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
2010-11-04 00:00:00 | C2 ATO | 19:00:00 | 21:00:00 | 2.000000000000001 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | TOTAL HRS |  | 16
 |  |  |  |  |  | 0 | 0 | 3 | 1.5 | 1 | 3.5 | 3 | 4 | 0 | 0 | 16
2010-11-05 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-05 00:00:00 | C2 ATO | 08:00:00 | 13:00:00 | 5 |  |  | 1 | 2 | 2 |  |  |  |  |  |  |  | 5
2010-11-05 00:00:00 | C3ATO | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-05 00:00:00 | C3ATO | 09:30:00 | 10:00:00 | 0.5000000000000009 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-05 00:00:00 | C2 ATO | 10:00:00 | 14:00:00 | 4 |  |  |  | 1 | 2 | 1 |  |  |  |  |  |  | 4
2010-11-05 00:00:00 | [NAME] | 16:00:00 | 16:30:00 | 0.5000000000000009 |  |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.5
2010-11-05 00:00:00 | [NAME] | 19:00:00 | 20:00:00 | 1.000000000000002 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
2010-11-05 00:00:00 | TA | 20:30:00 | 22:30:00 | 2.000000000000001 |  |  |  |  |  |  |  |  | 0.5 | 1.5 |  |  | 2
2010-11-05 00:00:00 | [NAME] | 21:00:00 | 21:30:00 | 0.5000000000000009 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
2010-11-05 00:00:00 | TA | 21:30:00 | 23:00:00 | 1.5 |  |  |  |  |  |  |  |  |  | 1.5 |  |  | 1.5
2010-11-05 00:00:00 | TA | 21:30:00 | 22:00:00 | 0.4999999999999982 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
2010-11-05 00:00:00 | TA | 21:30:00 | 22:00:00 | 0.4999999999999982 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
2010-11-05 00:00:00 | TA | 22:00:00 | 23:00:00 | 1.000000000000002 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | TOTAL HRS |  | 17.5
 |  |  |  |  |  | 0 | 1 | 4 | 4 | 1 | 0.5 | 0 | 1.5 | 5.5 | 0 | 17.5
2010-11-06 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-06 00:00:00 | C2 ATO | 10:00:00 | 10:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-06 00:00:00 | C2 ATO | 12:00:00 | 12:30:00 | 0.5000000000000009 |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 0.5
2010-11-06 00:00:00 | C2 ATO | 12:00:00 | 14:00:00 | 2.000000000000001 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
2010-11-06 00:00:00 | C2 ATO | 12:00:00 | 14:00:00 | 2.000000000000001 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
2010-11-06 00:00:00 | C2 ATO | ? | ? | #N/A |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-11-06 00:00:00 | C2 ATO | ? | ? | #N/A |  |  |  |  |  |  |  |  |  |  |  |  | 0
2010-11-06 00:00:00 | C2 ATO | ? | ? | #N/A |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | TOTAL HRS |  | 5
 |  |  |  |  |  | 0 | 0 | 0.5 | 2.5 | 2 | 0 | 0 | 0 | 0 | 0 | 5
2010-11-07 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-07 00:00:00 | C1ATO | 09:00:00 | 11:00:00 | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
2010-11-07 00:00:00 | C3ATO | 09:30:00 | 10:00:00 | 0.5000000000000009 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-07 00:00:00 | C1ATO | 09:30:00 | 10:00:00 | 0.5000000000000009 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-07 00:00:00 | C1ATO | 12:00:00 | 15:00:00 | 3 |  |  |  |  | 1 | 2 |  |  |  |  |  |  | 3
2010-11-07 00:00:00 | C1ATO | 12:00:00 | 13:30:00 | 1.5 |  |  |  |  | 1 | 0.5 |  |  |  |  |  |  | 1.5
2010-11-07 00:00:00 | C1ATO | 12:00:00 | 13:30:00 | 1.5 |  |  |  |  | 1 | 0.5 |  |  |  |  |  |  | 1.5
2010-11-07 00:00:00 | C1ATO | 13:30:00 | 15:30:00 | 2.000000000000001 |  |  |  |  |  | 1.5 | 0.5 |  |  |  |  |  | 2
2010-11-07 00:00:00 | C1ATO | 14:00:00 | 15:00:00 | 0.9999999999999991 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
2010-11-07 00:00:00 | C2 ATO | 16:00:00 | 20:00:00 | 4.000000000000002 |  |  |  |  |  |  | 1 | 2 | 1 |  |  |  | 4
2010-11-07 00:00:00 | [NAME] | 16:30:00 | 19:30:00 | 3 |  |  |  |  |  |  | 0.5 | 2 | 0.5 |  |  |  | 3
2010-11-07 00:00:00 | [NAME] | 17:30:00 | 19:30:00 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-07 00:00:00 | [NAME] | 17:30:00 | 19:30:00 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-07 00:00:00 | [NAME] | 18:30:00 | 20:30:00 | 1.999999999999998 |  |  |  |  |  |  |  | 0.5 | 1.5 |  |  |  | 2
2010-11-07 00:00:00 | [NAME] | 21:00:00 | 22:00:00 | 0.9999999999999991 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
2010-11-07 00:00:00 | [NAME] | 22:30:00 | 23:00:00 | 0.5000000000000009 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
2010-11-07 00:00:00 | C3ATO | ? | ? | #N/A |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.5 | TOTAL HRS |  | 26.5
 |  |  |  |  |  | 0 | 0 | 3 | 3 | 5.5 | 2 | 7.5 | 4 | 1.5 | 0 | 26.5
2010-11-10 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-10 00:00:00 | [NAME] | 09:00:00 | 14:00:00 | 5.000000000000001 |  |  |  | 2 | 2 | 1 |  |  |  |  |  |  | 5
2010-11-10 00:00:00 | [NAME] | 09:00:00 | 12:00:00 | 3 |  |  |  | 2 | 1 |  |  |  |  |  |  |  | 3
2010-11-10 00:00:00 | C3ATO | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-10 00:00:00 | C3ATO | 09:00:00 | 10:00:00 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2010-11-10 00:00:00 | TERM A ATO | 09:00:00 | 09:30:00 | 0.4999999999999996 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-10 00:00:00 | C2 ATO | 09:00:00 | 10:00:00 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2010-11-10 00:00:00 | [NAME] | 09:30:00 | 12:30:00 | 3.000000000000001 |  |  |  | 1.5 | 1.5 |  |  |  |  |  |  |  | 3
2010-11-10 00:00:00 | [NAME] | 09:30:00 | 12:30:00 | 3.000000000000001 |  |  |  | 1.5 | 1.5 |  |  |  |  |  |  |  | 3
2010-11-10 00:00:00 | [NAME] | 12:00:00 | 14:00:00 | 2.000000000000001 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
2010-11-10 00:00:00 | TERM A ATO | 12:00:00 | 14:00:00 | 2.000000000000001 |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 2
2010-11-10 00:00:00 | [NAME] | 12:30:00 | 14:30:00 | 1.999999999999998 |  |  |  |  | 0.5 | 1.5 |  |  |  |  |  |  | 2
2010-11-10 00:00:00 | TERM A ATO | 13:30:00 | 15:30:00 | 2.000000000000001 |  |  |  |  |  | 1.5 | 0.5 |  |  |  |  |  | 2
2010-11-10 00:00:00 | [NAME] | 14:30:00 | 15:00:00 | 0.5000000000000009 |  |  |  |  |  | 0.5 |  |  |  |  |  |  | 0.5
2010-11-10 00:00:00 | TERM A ATO | 15:00:00 | 18:00:00 | 3 |  |  |  |  |  |  | 2 | 1 |  |  |  |  | 3
2010-11-10 00:00:00 | [NAME] | 17:00:00 | 18:30:00 | 1.5 |  |  |  |  |  |  |  | 1.5 |  |  |  |  | 1.5
2010-11-10 00:00:00 | [NAME] | 18:00:00 | 20:00:00 | 2.000000000000001 |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 2
2010-11-10 00:00:00 | [NAME] | 19:30:00 | 21:30:00 | 2.000000000000001 |  |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  | 2
2010-11-10 00:00:00 | C3ATO | 09:30:00 | 10:00:00 | 0.5000000000000009 |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5
2010-11-10 00:00:00 | C2 ATO | 17:30 | 19:30 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-10 00:00:00 | C2 ATO | 18:00 | 22:00 | 3.999999999999999 |  |  |  |  |  |  |  | 1 | 2 | 1 |  |  | 4
2010-11-10 00:00:00 | C2 ATO | 20:00 | 22:00 | 1.999999999999998 |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 2
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | TOTAL HRS |  | 42.5
 |  |  |  |  |  | 0 | 0 | 10.5 | 8.5 | 6.5 | 2.5 | 6 | 6 | 2.5 | 0 | 42.5
2010-11-11 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-11 00:00:00 | C2 ATO | 09:00:00 | 11:00:00 | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  | 2
2010-11-11 00:00:00 | C2 ATO | 09:00:00 | 14:00:00 | 5.000000000000001 |  |  |  | 2 | 2 | 1 |  |  |  |  |  |  | 5
2010-11-11 00:00:00 | C2 ATO | 10:30:00 | 11:30:00 | 1 |  |  |  | 0.5 | 0.5 |  |  |  |  |  |  |  | 1
2010-11-11 00:00:00 | C2 ATO | 13:00:00 | 14:00:00 | 1.000000000000002 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
2010-11-11 00:00:00 | [NAME] | 13:30:00 | 14:30:00 | 0.9999999999999991 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
2010-11-11 00:00:00 | [NAME] | 15:00:00 | 16:30:00 | 1.5 |  |  |  |  |  |  | 1.5 |  |  |  |  |  | 1.5
2010-11-11 00:00:00 | [NAME] | 15:00:00 | 15:30:00 | 0.5000000000000009 |  |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.5
2010-11-11 00:00:00 | [NAME] | 19:00:00 | 20:00:00 | 1.000000000000002 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
2010-11-11 00:00:00 | [NAME] | 22:00:00 | 22:45:00 | 0.75 |  |  |  |  |  |  |  |  |  | 0.75 |  |  | 0.75
2010-11-11 00:00:00 | C2 ATO | 17:00 | 18:30 | 1.5 |  |  |  |  |  |  |  | 1.5 |  |  |  |  | 1.5
2010-11-11 00:00:00 | C2 ATO | 17:30 | 19:30 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-11 00:00:00 | C2 ATO | 17:30 | 19:30 | 2.000000000000001 |  |  |  |  |  |  |  | 1.5 | 0.5 |  |  |  | 2
2010-11-11 00:00:00 | C2 ATO | 18:30 | 22:00 | 3.499999999999998 |  |  |  |  |  |  |  | 0.5 | 2 | 1 |  |  | 3.5
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.75 | TOTAL HRS |  | 22.75
 |  |  |  |  |  | 0 | 0 | 4.5 | 2.5 | 3 | 2 | 5 | 4 | 1.75 | 0 | 22.75
2010-11-12 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-12 00:00:00 | TERM A ATO | 05:00:00 | 07:00:00 | 2 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2
2010-11-12 00:00:00 | [NAME] | 15:00:00 | 16:30:00 | 1.5 |  |  |  |  |  |  | 1.5 |  |  |  |  |  | 1.5
2010-11-12 00:00:00 | [NAME] | 21:00:00 | 21:30:00 | 0.5000000000000009 |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 0.5
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | TOTAL HRS |  | 4
 |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 1.5 | 0 | 0 | 0.5 | 0 | 4
2010-11-13 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-13 00:00:00 | [NAME] | 15:30:00 | 16:00:00 | 0.4999999999999982 |  |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.5
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | TOTAL HRS |  | 0.5
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0.5
2010-11-14 00:00:00
DATE | WORK AREA | START | END | [NAME] |  | 05:00-07:00 | 07:00-09:00 | 09:00-11:00 | 11:00-13:00 | 13:00-15:00 | 15:00-17:00 | 17:00-19:00 | 19:00-21:00 | 21:00-23:00 | 23:00-01:00 |  | TTL
2010-11-14 00:00:00 | C2 ATO | 12:00:00 | 13:00:00 | 0.9999999999999991 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
2010-11-14 00:00:00 | C2 ATO | 13:00:00 | 15:00:00 | 2.000000000000001 |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
2010-11-14 00:00:00 | C2 ATO | 14:00:00 | 16:00:00 | 1.999999999999998 |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 2
2010-11-14 00:00:00 | [NAME] | 16:30:00 | 17:00:00 | 0.5000000000000009 |  |  |  |  |  |  | 0.5 |  |  |  |  |  | 0.5
2010-11-14 00:00:00 | [NAME] | 16:30:00 | 18:00:00 | 1.5 |  |  |  |  |  |  | 0.5 | 1 |  |  |  |  | 1.5
2010-11-14 00:00:00 | [NAME] | 17:00:00 | 17:30:00 | 0.4999999999999982 |  |  |  |  |  |  |  | 0.5 |  |  |  |  | 0.5
2010-11-14 00:00:00 | [NAME] | 17:00:00 | 17:30:00 | 0.4999999999999982 |  |  |  |  |  |  |  | 0.5 |  |  |  |  | 0.5
2010-11-14 00:00:00 | C2 ATO | 18:00:00 | 22:00:00 | 3.999999999999999 |  |  |  |  |  |  |  | 1 | 2 | 1 |  |  | 4
2010-11-14 00:00:00 | [NAME] | 19:00:00 | 20:00:00 | 1.000000000000002 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
2010-11-14 00:00:00 | C2 ATO | 14:00 | 14:30:00 | 0.4999999999999982 |  |  |  |  |  | 0.5 |  |  |  |  |  |  | 0.5
2010-11-14 00:00:00 | C2 ATO | 14:00 | 15:00:00 | 0.9999999999999991 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.5 | TOTAL HRS |  | 14.5
 |  |  |  |  |  | 0 | 0 | 0 | 1 | 4.5 | 2 | 3 | 3 | 1 | 0 | 14.5
 |  |  |  |  |  | TTL HRS PER BANK FOR NOVEMBER
 |  |  |  |  |  | 05:00-07:00 | 07:00-09:00 | 09:01-11:00 | 11:01-13:00 | 13:01-15:00 | 15:01-17:00 | 17:01-19:00 | 19:01-21:00 | 21:01-23:00 | 23:01-01:00 |  |  | TOTAL HRS |  | 187.75
 |  |  |  |  |  | 2 | 1.5 | 31 | 25 | 27 | 21.5 | 37 | 27.5 | 15.25 | 0
 |  |  |  |  |  | 0.01065246338215712 | 0.007989347536617843 | 0.1651131824234354 | 0.1331557922769641 | 0.1438082556591212 | 0.1145139813581891 | 0.1970705725699068 | 0.1464713715046604 | 0.08122503328894808 | 0