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

Overtime Work for  2012
 |  | Dates |  |  | Time Worked
Employees | Department | To | From | No. of Days | Start-time | End-Time | No. of [NAME].
[NAME] | DMU | 2012-05-18 00:00:00 | 2012-05-18 00:00:00 |  | 15:30:00 | 19:05:00
[NAME] | DMU | 2012-05-19 00:00:00 | 2012-05-19 00:00:00 |  | 09:30:00 | 17:00:00
[NAME] | DMU | 2012-05-26 00:00:00 | 2012-05-26 00:00:00 |  | 12:05:00 | 17:30:00
[NAME] | Marketing Dept. | 2012-05-08 00:00:00 | 2012-05-08 00:00:00 |  | 16:35:00 | 22:25:00
[NAME] | CSU | 2012-05-02 00:00:00 | 2012-05-02 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | Internal Audit | 2012-05-28 00:00:00 | 2012-05-28 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Internal Audit | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Marketing Dept. | 2012-05-08 00:00:00 | 2012-05-08 00:00:00 |  | 16:35:00 | 22:25:00
[NAME] | Marketing Dept. | 2012-05-07 00:00:00 | 2012-05-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Marketing Dept. | 2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  | 17:00:00 | 20:30:00
Jodi-[NAME] | Internal Audit | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Internal Audit | 2012-05-28 00:00:00 | 2012-05-28 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Internal Audit | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:30:00
Nkachi Reeves | Cross [NAME] | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | MIS | 2012-05-19 00:00:00 | 2012-05-19 00:00:00 |  | 14:00:00 | 18:00:00
[NAME] | Marketing Dept. | 2012-05-07 00:00:00 | 2012-05-07 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Marketing Dept. | 2012-05-10 00:00:00 | 2012-05-10 00:00:00 |  | 17:00:00 | 20:30:00
[NAME] | Cross [NAME] | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Internal Audit | 2012-05-28 00:00:00 | 2012-05-28 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Internal Audit | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:30:00
Trudi-[NAME] | Cross [NAME] | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 |  | 17:00:00 | 19:30:00
Trudi-[NAME] | Cross [NAME] | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Marketing Dept. | 2012-05-08 00:00:00 | 2012-05-08 00:00:00 |  | 16:35:00 | 22:25:00
Venese Wright | Cross [NAME] | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | CSU | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 |  | 16:30:00 | 19:05:00
[NAME] | CSU | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | CSU | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | CSU | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | CSU | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | CSU | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | CSU | 2012-05-30 00:00:00 | 2012-05-30 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | MIS | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 00:00:00 | 07:00:00
[NAME] | Marketing Dept. | 2012-05-19 00:00:00 | 2012-05-19 00:00:00 |  | 11:50:00 | 16:45:00
[NAME] | Marketing Dept. | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 18:30:00
[NAME] | Marketing Dept. | 2012-05-25 00:00:00 | 2012-05-25 00:00:00 |  | 17:00: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] | Marketing Dept. | 2012-05-31 00:00:00 | 2012-05-31 00:00:00 |  | 17:00:00 | 18:30:00
[NAME] | Marketing Dept. | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 |  | 16:30:00 | 19:30:00