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

Overtime Work for  2012
 |  | Dates |  |  | Time Worked
Employees | Department | To | From | No. of Days | Start-time | End-Time | No. of [NAME].
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | MIS | 2012-04-04 00:00:00 | 2012-04-04 00:00:00 |  | 22:00:00 | 23:59:00
[NAME] | MIS | 2012-04-04 00:00:00 | 2012-04-04 00:00:00 |  | 00:00:00 | 01:00:00
[NAME] | MIS | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 00:30:00 | 03:00:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-22 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | CSU | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | CSU | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 15:30:00 | 19:40:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | MIS | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 12:53:00 | 23:59:00
[NAME] | MIS | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 00:00:00 | 07:10:00
Denmor Minto | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | CSU | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 15:30:00 | 19:15:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Internal Audit | 2012-03-28 00:00:00 | 2012-03-28 00:00:00 |  | 16:30:00 | 18:45:00
[NAME] | Internal Audit | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:30:00 | 19:45:00
[NAME] | Cross [NAME] | 2012-03-02 00:00:00 | 2012-03-02 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:00:00 | 20:00:00
[NAME] | Cross [NAME] | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
Marlet Fender | Registry | 2012-03-20 00:00:00 | 2012-03-20 00:00:00 |  | 16:30:00 | 18:30:00
Marlet Fender | Registry | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
[NAME] | Cross [NAME] | 2012-03-02 00:00:00 | 2012-03-02 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:00:00 | 20:00:00
[NAME] | Registry | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 |  | 16:30:00 | 18:30:00
Nkachi Reeves | Cross [NAME] | 2012-03-02 00:00:00 | 2012-03-02 00:00:00 |  | 16:00:00 | 19:30:00
Nkachi Reeves | Cross [NAME] | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:00:00 | 20:00:00
Nkachi Reeves | Cross [NAME] | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 |  | 00:00:00 | 06:30:00
[NAME] | Cross [NAME] | 2012-03-10 00:00:00 | 2012-03-10 00:00:00 |  | 13:00:00 | 20:00:00
[NAME] | CSU | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:00:00 | 20:00:00
[NAME] | Cross [NAME] | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Internal Audit | 2012-03-28 00:00:00 | 2012-03-28 00:00:00 |  | 16:30:00 | 18:45:00
[NAME] | Internal Audit | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 20:15:00
[NAME] | Cross [NAME] | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 17:00:00 | 20:00:00
[NAME] | CSU | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 15:30:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-03-02 00:00:00 | 2012-03-02 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | CSU | 2012-03-29 00:00:00 | 2012-03-29 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:15:00
Trudi-[NAME] | Cross [NAME] | 2012-03-30 00:00:00 | 2012-03-30 00:00:00 |  | 16:00:00 | 19:30:00