Spreadsheet: 266801d1379750933-employee-overtime-management-test1-ans
Sheet: Sheet1

Num | Department | Name | Date | Time | Clock-in/out | Overtime | Amount |  |  | 1.75 | 2
57 | HR & Acc - Managemen | A | 2013-09-02 00:00:00 | 08:08:37 | C/In
57 | HR & Acc - Managemen | A | 2013-09-02 00:00:00 | 23:30:14 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-03 00:00:00 | 06:54:47 | C/In
57 | HR & Acc - Managemen | A | 2013-09-03 00:00:00 | 20:29:07 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-04 00:00:00 | 09:06:03 | C/In
57 | HR & Acc - Managemen | A | 2013-09-04 00:00:00 | 17:02:44 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-05 00:00:00 | 08:15:27 | C/In
57 | HR & Acc - Managemen | A | 2013-09-05 00:00:00 | 19:29:08 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-06 00:00:00 | 10:29:56 | C/In
57 | HR & Acc - Managemen | A | 2013-09-06 00:00:00 | 22:42:57 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-07 00:00:00 | 12:29:50 | C/In
57 | HR & Acc - Managemen | A | 2013-09-09 00:00:00 | 05:11:24 | C/In
57 | HR & Acc - Managemen | A | 2013-09-09 00:00:00 | 23:25:55 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-10 00:00:00 | 09:37:17 | C/In
57 | HR & Acc - Managemen | A | 2013-09-10 00:00:00 | 19:58:50 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-11 00:00:00 | 08:30:55 | C/In
57 | HR & Acc - Managemen | A | 2013-09-11 00:00:00 | 16:52:39 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-12 00:00:00 | 08:27:19 | C/In
57 | HR & Acc - Managemen | A | 2013-09-12 00:00:00 | 20:03:53 | C/Out
57 | HR & Acc - Managemen | A | 2013-09-13 00:00:00 | 08:26:18 | C/In
57 | HR & Acc - Managemen | A | 2013-09-13 00:00:00 | 22:46:50 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-03 00:00:00 | 06:59:33 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-03 00:00:00 | 20:38:53 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-04 00:00:00 | 07:59:16 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-04 00:00:00 | 19:40:13 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-05 00:00:00 | 08:05:37 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-05 00:00:00 | 08:17:01 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-05 00:00:00 | 20:03:33 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-06 00:00:00 | 07:02:54 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-07 00:00:00 | 06:40:18 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-07 00:00:00 | 07:38:23 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-07 00:00:00 | 17:03:27 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-09 00:00:00 | 08:17:58 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-09 00:00:00 | 19:08:00 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-10 00:00:00 | 08:22:19 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-10 00:00:00 | 19:30:29 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-11 00:00:00 | 20:00:08 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-12 00:00:00 | 06:47:23 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-12 00:00:00 | 18:34:29 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-13 00:00:00 | 08:10:05 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-13 00:00:00 | 19:46:11 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-14 00:00:00 | 08:14:33 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-14 00:00:00 | 17:30:32 | C/Out
66 | Ops - Driver 10hrs | B | 2013-09-15 00:00:00 | 08:13:56 | C/In
66 | Ops - Driver 10hrs | B | 2013-09-15 00:00:00 | 19:01:03 | C/Out