Spreadsheet: 166945d1341851127-adding-multiple-results-using-vlookup-sample-workbook
Sheet: June

Overtime Work for  2012
 |  | Dates |  |  | Time Worked
Employees | Department | To | From | No. of Days | Start-time | End-Time | No. of [NAME].
[NAME] | MIS | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 00:00:00 | 07:00:00
[NAME] | Marketing Dept. | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Marketing Dept. | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Registry | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 |  | 16:30:00 | 18:40:00
[NAME] | Registry | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-11 00:00:00 | 2012-06-11 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Registry | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 |  | 16:30:00 | 18:40:00
[NAME] | Cross [NAME] | 2012-06-05 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Cross [NAME] | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 |  | 16:30:00 | 18:40:00
[NAME] | Registry | 2012-06-06 00:00:00 | 2012-06-06 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-11 00:00:00 | 2012-06-11 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Registry | 2012-06-05 00:00:00 | 2012-06-05 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
Denmor Minto | Registry | 2012-06-05 00:00:00 | 2012-06-05 00:00:00 |  | 16:30:00 | 18:30:00
Denmor Minto | Registry | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
Denmor Minto | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-05 00:00:00 | 2012-06-05 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 |  | 16:30:00 | 18:40:00
[NAME] | Registry | 2012-06-06 00:00:00 | 2012-06-06 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
Marlet Fender | Registry | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 |  | 16:30:00 | 18:40:00
Marlet Fender | Registry | 2012-06-06 00:00:00 | 2012-06-06 00:00:00 |  | 16:30:00 | 18:30:00
Marlet Fender | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 |  | 16:30:00 | 18:40:00
[NAME] | Registry | 2012-06-05 00:00:00 | 2012-06-05 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-06 00:00:00 | 2012-06-06 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 18:10:00
[NAME] | Registry | 2012-06-11 00:00:00 | 2012-06-11 00:00:00 |  | 16:30:00 | 19:00:00
Sharna Ramsay | Accounts | 2012-06-25 00:00:00 | 2012-06-27 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Accounts | 2012-06-25 00:00:00 | 2012-06-25 00:00:00 |  | 16:30:00 | 19:05:00
[NAME] | Accounts | 2012-06-26 00:00:00 | 2012-06-26 00:00:00 |  | 16:30:00 | 19:10:00
[NAME] | Accounts | 2012-06-27 00:00:00 | 2012-06-27 00:00:00 |  | 16:30:00 | 19:02:00
[NAME] | DMU | 2012-06-14 00:00:00 | 2012-06-14 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | DMU | 2012-06-14 00:00:00 | 2012-06-14 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | DMU | 2012-06-14 00:00:00 | 2012-06-14 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Internal Audit | 2012-06-19 00:00:00 | 2012-06-19 00:00:00 |  | 17:00:00 | 18:30:00
[NAME] | Internal Audit | 2012-06-26 00:00:00 | 2012-06-26 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Internal Audit | 2012-06-19 00:00:00 | 2012-06-19 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Internal Audit | 2012-06-26 00:00:00 | 2012-06-26 00:00:00 |  | 16:30:00 | 19:00:00
Jodi-[NAME] | Internal Audit | 2012-06-19 00:00:00 | 2012-06-19 00:00:00 |  | 16:30:00 | 18:00:00
Jodi-[NAME] | Internal Audit | 2012-06-26 00:00:00 | 2012-06-26 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Registry | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 15:30:00 | 19:15:00
[NAME] | Registry | 2012-06-02 00:00:00 | 2012-06-02 00:00:00 |  | 10:00:00 | 16:30:00
[NAME] | Registry | 2012-06-08 00:00:00 | 2012-06-08 00:00:00 |  | 15:30:00 | 19:00:00
[NAME] | Registry | 2012-06-09 00:00:00 | 2012-06-09 00:00:00 |  | 09:30:00 | 13:10:00
[NAME] | MIS | 2012-06-29 00:00:00 | 2012-06-29 00:00:00 |  | 17:00:00 | 22:30:00
[NAME] | CSU | 2012-06-26 00:00:00