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

Overtime Work for  2012
 |  | Dates |  |  | Time Worked
Employees | Department | To | From | No. of Days | Start-time | End-Time | No. of [NAME].
[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] | MIS | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 00:30:00 | 03:30:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 10:30:00 | 16:00:00
[NAME] | CSU | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | CSU | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | CSU | 2012-04-11 00:00:00 | 2012-04-11 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | CSU | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 10:30:00 | 16:00:00
[NAME] | DMU | 2012-04-02 00:00:00 | 2012-04-05 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | DMU | 2012-04-11 00:00:00 | 2012-04-11 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | Marketing Dept. | 2012-04-25 00:00:00 | 2012-04-25 00:00:00 |  | 17:00:00 | 21:00:00
[NAME] | Cross [NAME] | 2012-04-27 00:00:00 | 2012-04-27 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 10:00:00 | 16:00:00
[NAME] | Cross [NAME] | 2012-04-02 00:00:00 | 2012-04-02 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-04-03 00:00:00 | 2012-04-03 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-04 00:00:00 | 2012-04-04 00:00:00 |  | 18:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 11:30:00 | 16:30:00
[NAME] | Marketing Dept. | 2012-04-25 00:00:00 | 2012-04-25 00:00:00 |  | 17:00:00 | 21:00:00
[NAME] | CSU | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-02 00:00:00 | 2012-04-02 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-03 00:00:00 | 2012-04-03 00:00:00 |  | 17:10:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-04 00:00:00 | 2012-04-04 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 18:00:00 | 19:00:00
[NAME] | CSU | 2012-04-02 00:00:00 | 2012-04-02 00:00:00 |  | 16:30:00 | 19:30:00
[NAME] | CSU | 2012-04-03 00:00:00 | 2012-04-03 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-04-04 00:00:00 | 2012-04-04 00:00:00 |  | 16:30:00 | 19:10:00
[NAME] | CSU | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-04-11 00:00:00 | 2012-04-11 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-04-24 00:00:00 | 2012-04-24 00:00:00 |  | 16:00:00 | 19:30:00
[NAME] | Cross [NAME] | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | CSU | 2012-04-03 00:00:00 | 2012-04-03 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | CSU | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 10:30:00 | 16:00:00
[NAME] | Marketing Dept. | 2012-04-02 00:00:00 | 2012-04-04 00:00:00 |  | 16:45:00 | 19:00:00
[NAME] | Marketing Dept. | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 |  | 16:30:00 | 18:30:00
Trudi-[NAME] | Cross [NAME] | 2012-04-27 00:00:00 | 2012-04-27 00:00:00 |  | 16:00:00 | 19:30:00
Trudi-[NAME] | Cross [NAME] | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:30:00
Venese Wright | Cross [NAME] | 2012-04-27 00:00:00 | 2012-04-27 00:00:00 |  | 16:00:00 | 19:30:00
Venese Wright | Cross [NAME] | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | CSU | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | Accounts | 2012-04-14 00:00:00 | 2012-04-14 00:00:00 |  | 11:00:00 | 16:00:00