Spreadsheet: 47961d1247143945-time-sheet-calclulation-from-raw-data-time-sheet-calculation
Sheet: DATA

Emp Id | Date | Time | In/Out
390 | 2009-06-27 00:00:00 | 09:31:00 | I
390 | 2009-06-27 00:00:00 | 14:31:00 | O
390 | 2009-06-29 00:00:00 | 07:56:00 | I
390 | 2009-06-29 00:00:00 | 12:35:00 | O
390 | 2009-06-29 00:00:00 | 13:23:00 | I
390 | 2009-06-29 00:00:00 | 17:50:00 | O
390 | 2009-06-30 00:00:00 | 07:57:00 | I
390 | 2009-06-30 00:00:00 | 12:38:00 | O
390 | 2009-06-30 00:00:00 | 13:20:00 | I
390 | 2009-06-30 00:00:00 | 18:01:00 | O
390 | 2009-07-01 00:00:00 | 07:59:00 | I
390 | 2009-07-01 00:00:00 | 12:36:00 | O
390 | 2009-07-01 00:00:00 | 13:16:00 | I
390 | 2009-07-01 00:00:00 | 18:08:00 | O
390 | 2009-07-02 00:00:00 | 07:51:00 | I
390 | 2009-07-02 00:00:00 | 12:42:00 | O
390 | 2009-07-02 00:00:00 | 13:19:00 | I
390 | 2009-07-02 00:00:00 | 18:02:00 | O
390 | 2009-07-03 00:00:00 | 07:56:00 | I
390 | 2009-07-03 00:00:00 | 12:40:00 | O
390 | 2009-07-03 00:00:00 | 13:22:00 | I
390 | 2009-07-03 00:00:00 | 18:09:00 | O
390 | 2009-07-04 00:00:00 | 09:28:00 | I
390 | 2009-07-04 00:00:00 | 13:30:00 | O
390 | 2009-07-06 00:00:00 | 07:55:00 | I
390 | 2009-07-06 00:00:00 | 12:37:00 | O
390 | 2009-07-06 00:00:00 | 13:23:00 | I
390 | 2009-07-06 00:00:00 | 18:04:00 | O
390 | 2009-07-07 00:00:00 | 07:59:00 | I
390 | 2009-07-07 00:00:00 | 12:40:00 | O
390 | 2009-07-07 00:00:00 | 13:23:00 | I
390 | 2009-07-07 00:00:00 | 14:48:00 | O
390 | 2009-07-07 00:00:00 | 15:51:00 | I
390 | 2009-07-07 00:00:00 | 18:03:00 | O
853 | 2009-06-27 00:00:00 | 08:07:00 | O
853 | 2009-06-27 00:00:00 | 11:05:00 | I
853 | 2009-06-27 00:00:00 | 11:09:00 | O
853 | 2009-06-27 00:00:00 | 13:02:00 | I
853 | 2009-06-27 00:00:00 | 13:02:00 | O
853 | 2009-06-29 00:00:00 | 07:42:00 | I
853 | 2009-06-29 00:00:00 | 11:05:00 | O
853 | 2009-06-29 00:00:00 | 11:12:00 | I
853 | 2009-06-29 00:00:00 | 13:56:00 | O
853 | 2009-06-29 00:00:00 | 14:02:00 | I
853 | 2009-06-29 00:00:00 | 15:53:00 | O
853 | 2009-06-29 00:00:00 | 15:59:00 | I
853 | 2009-06-29 00:00:00 | 17:13:00 | O
853 | 2009-06-30 00:00:00 | 07:32:00 | I
853 | 2009-06-30 00:00:00 | 10:37:00 | O
853 | 2009-06-30 00:00:00 | 10:44:00 | I
853 | 2009-06-30 00:00:00 | 13:19:00 | O
853 | 2009-06-30 00:00:00 | 13:25:00 | I
853 | 2009-06-30 00:00:00 | 15:13:00 | O
853 | 2009-06-30 00:00:00 | 15:18:00 | I
853 | 2009-06-30 00:00:00 | 17:05:00 | O
853 | 2009-07-01 00:00:00 | 07:15:00 | I
853 | 2009-07-01 00:00:00 | 10:06:00 | O
853 | 2009-07-01 00:00:00 | 10:11:00 | I
853 | 2009-07-01 00:00:00 | 12:48:00 | O
853 | 2009-07-01 00:00:00 | 12:56:00 | I
853 | 2009-07-01 00:00:00 | 14:55:00 | O
853 | 2009-07-01 00:00:00 | 15:03:00 | I
853 | 2009-07-01 00:00:00 | 17:03:00 | O
853 | 2009-07-02 00:00:00 | 07:26:00 | I
853 | 2009-07-02 00:00:00 | 10:18:00 | O
853 | 2009-07-02 00:00:00 | 10:24:00 | I
853 | 2009-07-02 00:00:00 | 12:17:00 | O
853 | 2009-07-02 00:00:00 | 12:22:00 | I
853 | 2009-07-02 00:00:00 | 14:11:00 | O
853 | 2009-07-02 00:00:00 | 14:19:00 | I
853 | 2009-07-02 00:00:00 | 16:19:00 | O
853 | 2009-07-02 00:00:00 | 16:28:00 | I
853 | 2009-07-02 00:00:00 | 17:04:00 | O
853 | 2009-07-03 00:00:00 | 07:31:00 | I
853 | 2009-07-03 00:00:00 | 10:24:00 | O
853 | 2009-07-03 00:00:00 | 10:30:00 | I
853 | 2009-07-03 00:00:00 | 12:35:00 | O
853 | 2009-07-03 00:00:00 | 12:40:00 | I
853 | 2009-07-03 00:00:00 | 15:13:00 | O
853 | 2009-07-03 00:00:00 | 15:18:00 | I
853 | 2009-07-03 00:00:00 | 17:07:00 | O
853 | 2009-07-04 00:00:00 | 08:10:00 | I
853 | 2009-07-04 00:00:00 | 10:36:00 | O
853 | 2009-07-04 00:00:00 | 10:41:00 | I
853 | 2009-07-04 00:00:00 | 11:58:00 | O
853 | 2009-07-04 00:00:00 | 12:03:00 | I
853 | 2009-07-04 00:00:00 | 13:02:00 | O
853 | 2009-07-06 00:00:00 | 07:33:00 | I
853 | 2009-07-06 00:00:00 | 11:45:00 | O
853 | 2009-07-06 00:00:00 | 11:50:00 | I
853 | 2009-07-06 00:00:00 | 13:40:00 | O
853 | 2009-07-06 00:00:00 | 13:45:00 | I
853 | 2009-07-06 00:00:00 | 15:54:00 | O
853 | 2009-07-06 00:00:00 | 16:00:00 | I
853 | 2009-07-06 00:00:00 | 17:07:00 | O
853 | 2009-07-07 00:00:00 | 07:26:00 | I
853 | 2009-07-07 00:00:00 | 10:09:00 | O
853 | 2009-07-07 00:00:00 | 10:14:00 | I
853 | 2009-07-07 00:00:00 | 11:55:00 | O
853 | 2009-07-07 00:00:00 | 12:00:00 | I
853 | 2009-07-07 00:00:00 | 16:18:00 | O
853 | 2009-07-07 00:00:00 | 16:23:00 | I
853 | 2009-07-07 00:00:00 | 17:02:00 | O