Spreadsheet: 701943d1603996491-large-data-transpose-by-removing-duplicates-on-specific-rows-large-data-transpose
Sheet: Downloaded File

Employee Code | Employee Name | Department | Unit Code | Start Date | End Date | Shift In Time | Original In Time | Shift Out Time | Original Out Time | Work Hours | OT hours | Status | Shift | Late/Early Status | Late/Early Timings
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-10 | 2020-10-10 | 7:30 | 8:04 | 16:30 | 18:02 | 9:58 | 1:32 | Half Day | [NAME] | LA/EE | 0:34/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-09-26 | 2020-09-26 | 7:30 | 8:09 | 16:30 | 16:46 | 8:37 | 0:16 | Half Day | [NAME] | LA/EE | 0:39/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-17 | 2020-10-17 | 7:30 | 8:09 | 16:30 | 17:21 | 9:12 | 0:51 | Half Day | [NAME] | LA/EE | 0:39/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-23 | 2020-10-23 | 7:30 | 8:09 | 16:30 | 17:09 | 9:00 | 0:39 | Half Day | [NAME] | LA/EE | 0:39/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-11 | 2020-10-11 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-16 | 2020-10-16 | 7:30 | 8:13 | 16:30 | 19:01 | 10:48 | 2:31 | Half Day | [NAME] | LA/EE | 0:43/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-03 | 2020-10-03 | 7:30 | 8:08 | 16:30 | 17:29 | 9:21 | 0:59 | Half Day | [NAME] | LA/EE | 0:38/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-20 | 2020-10-20 | 7:30 | 8:00 | 16:30 | 17:10 | 9:10 | 0:40 | Half Day | [NAME] | LA/EE | 0:30/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-05 | 2020-10-05 | 7:30 | 8:11 | 16:30 | 15:05 | 6:54 | 0:00 | Half Day | [NAME] | LA/EE | 0:41/1:25
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-19 | 2020-10-19 | 7:30 | 8:06 | 16:30 | 17:21 | 9:15 | 0:51 | Half Day | [NAME] | LA/EE | 0:36/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-02 | 2020-10-02 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Holiday | [NAME] | LA/EE | 0:00/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-06 | 2020-10-06 | 7:30 | 8:20 | 16:30 | 17:25 | 9:05 | 0:55 | Half Day | [NAME] | LA/EE | 0:50/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-09-30 | 2020-09-30 | 7:30 | 8:06 | 16:30 | 17:26 | 9:20 | 0:56 | Half Day | [NAME] | LA/EE | 0:36/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-12 | 2020-10-12 | 7:30 | 8:14 | 16:30 | 17:52 | 9:38 | 1:22 | Half Day | [NAME] | LA/EE | 0:44/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-25 | 2020-10-25 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-15 | 2020-10-15 | 7:30 | 8:06 | 16:30 | 17:33 | 9:27 | 1:03 | Half Day | [NAME] | LA/EE | 0:36/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-09 | 2020-10-09 | 7:30 | 8:09 | 16:30 | 17:07 | 8:58 | 0:37 | Half Day | [NAME] | LA/EE | 0:39/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-07 | 2020-10-07 | 7:30 | 8:11 | 16:30 | 17:02 | [NAME] | 0:32 | Half Day | [NAME] | LA/EE | 0:41/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-22 | 2020-10-22 | 7:30 | 8:04 | 16:30 | 17:01 | 8:57 | 0:31 | Half Day | [NAME] | LA/EE | 0:34/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-18 | 2020-10-18 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-08 | 2020-10-08 | 7:30 | 8:12 | 16:30 | 12:55 | 4:43 | 0:00 | Half Day | [NAME] | LA/EE | 0:42/3:35
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-21 | 2020-10-21 | 7:30 | 8:04 | 16:30 | 17:16 | 9:12 | 0:46 | Half Day | [NAME] | LA/EE | 0:34/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-13 | 2020-10-13 | 7:30 | 8:05 | 16:30 | 17:44 | 9:39 | 1:14 | Half Day | [NAME] | LA/EE | 0:35/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-09-27 | 2020-09-27 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-14 | 2020-10-14 | 7:30 | 8:05 | 16:30 | 17:22 | 9:17 | 0:52 | Half Day | [NAME] | LA/EE | 0:35/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-09-29 | 2020-09-29 | 7:30 | 7:57 | 16:30 | 16:57 | 9:00 | 0:27 | Half Day | [NAME] | LA/EE | 0:27/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-09-28 | 2020-09-28 | 7:30 | 8:07 | 16:30 | 16:51 | 8:44 | 0:21 | Half Day | [NAME] | LA/EE | 0:37/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-04 | 2020-10-04 | 0:00 | 9:49 | 0:00 | 11:50 | 2:01 | 11:50 | Weekly Off | Weekly Off | LA/EE | 9:49/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-01 | 2020-10-01 | 7:30 | 8:04 | 16:30 | 18:59 | 10:55 | 2:29 | Half Day | [NAME] | LA/EE | 0:34/0:00
10884 | Parmanand Yadav | Operating Theatres | RC | 2020-10-24 | 2020-10-24 | 7:30 | 8:03 | 16:30 | 17:17 | 9:14 | 0:47 | Half Day | [NAME] | LA/EE | 0:33/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-22 | 2020-10-22 | 7:30 | 8:15 | 16:30 | 17:42 | 9:27 | 1:12 | Half Day | [NAME] | LA/EE | 0:45/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-06 | 2020-10-06 | 9:00 | 8:11 | 18:00 | 17:06 | 8:55 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:54
10885 | Milan [NAME] | Nursing Administration | RC | 2020-09-26 | 2020-09-26 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Absent | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-12 | 2020-10-12 | 7:30 | 8:09 | 16:30 | 17:10 | 9:01 | 0:40 | Half Day | [NAME] | LA/EE | 0:39/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-25 | 2020-10-25 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Leave | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-09 | 2020-10-09 | 9:00 | 8:07 | 18:00 | 17:04 | 8:57 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:56
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-21 | 2020-10-21 | 7:30 | 8:08 | 16:30 | 17:01 | 8:53 | 0:31 | Half Day | [NAME] | LA/EE | 0:38/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-16 | 2020-10-16 | 7:30 | 8:06 | 16:30 | 17:16 | 9:10 | 0:46 | Half Day | [NAME] | LA/EE | 0:36/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-23 | 2020-10-23 | 7:30 | 8:14 | 16:30 | 17:11 | 8:57 | 0:41 | Half Day | [NAME] | LA/EE | 0:44/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-11 | 2020-10-11 | 0:00 | 8:08 | 0:00 | 16:49 | 8:41 | 16:49 | Weekly Off | Weekly Off | LA/EE | 8:08/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-09-29 | 2020-09-29 | 9:00 | 0:00 | 18:00 | 0:00 | 0:00 | 0:00 | Leave | S7 | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-03 | 2020-10-03 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Absent | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-10 | 2020-10-10 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Absent | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-04 | 2020-10-04 | 9:00 | 8:08 | 18:00 | 16:28 | 8:20 | 0:00 | Half Day | S7 | LA/EE | 0:00/1:32
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-18 | 2020-10-18 | 0:00 | 8:10 | 0:00 | 17:04 | 8:54 | 17:04 | Weekly Off | Weekly Off | LA/EE | 8:10/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-24 | 2020-10-24 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Absent | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-19 | 2020-10-19 | 7:30 | 8:11 | 16:30 | 17:14 | 9:03 | 0:44 | Half Day | [NAME] | LA/EE | 0:41/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-02 | 2020-10-02 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Holiday | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-09-30 | 2020-09-30 | 9:00 | 8:04 | 18:00 | 17:03 | 8:59 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:57
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-08 | 2020-10-08 | 9:00 | 8:03 | 18:00 | 17:07 | 9:04 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:53
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-20 | 2020-10-20 | 7:30 | 8:04 | 16:30 | 17:13 | 9:09 | 0:43 | Half Day | [NAME] | LA/EE | 0:34/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-13 | 2020-10-13 | 7:30 | 8:07 | 16:30 | 17:11 | 9:04 | 0:41 | Half Day | [NAME] | LA/EE | 0:37/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-05 | 2020-10-05 | 9:00 | 8:18 | 18:00 | 0:00 | 0:00 | 0:00 | Miss Punch Out | S7 | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-17 | 2020-10-17 | 7:30 | 0:00 | 16:30 | 0:00 | 0:00 | 0:00 | Absent | [NAME] | LA/EE | 0:00/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-09-27 | 2020-09-27 | 0:00 | 8:05 | 0:00 | 16:08 | 8:03 | 16:08 | Weekly Off | Weekly Off | LA/EE | 8:05/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-09-28 | 2020-09-28 | 9:00 | 8:07 | 18:00 | 17:09 | 9:02 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:51
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-07 | 2020-10-07 | 9:00 | 8:05 | 18:00 | 17:10 | 9:05 | 0:00 | Half Day | S7 | LA/EE | 0:00/0:50
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-14 | 2020-10-14 | 7:30 | 8:03 | 16:30 | 17:17 | 9:14 | 0:47 | Half Day | [NAME] | LA/EE | 0:33/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-15 | 2020-10-15 | 7:30 | 8:07 | 16:30 | 17:07 | 9:00 | 0:37 | Half Day | [NAME] | LA/EE | 0:37/0:00
10885 | Milan [NAME] | Nursing Administration | RC | 2020-10-01 | 2020-10-01 | 9:00 | 8:02 | 18:00 | 18:53 | 10:51 | 0:53 | Present | S7 | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-09-30 | 2020-09-30 | 8:00 | 9:53 | 17:00 | 18:58 | 9:05 | 1:58 | Half Day | S5 | LA/EE | 1:53/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-25 | 2020-10-25 | 11:00 | 0:00 | 20:00 | 0:00 | 0:00 | 0:00 | Absent | S10 | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-17 | 2020-10-17 | 8:00 | 10:35 | 17:00 | 19:59 | 9:24 | 2:59 | Half Day | S5 | LA/EE | 2:35/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-19 | 2020-10-19 | 11:00 | 7:47 | 20:00 | 17:17 | 9:30 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:43
10886 | [NAME] | Hospitality Services | RC | 2020-10-09 | 2020-10-09 | 11:00 | 7:49 | 20:00 | 17:04 | 9:15 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:56
10886 | [NAME] | Hospitality Services | RC | 2020-10-08 | 2020-10-08 | 9:00 | 0:00 | 18:00 | 0:00 | 0:00 | 0:00 | Leave | S7 | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-07 | 2020-10-07 | 11:00 | 7:50 | 20:00 | 16:53 | 9:03 | 0:00 | Half Day | S10 | LA/EE | 0:00/3:07
10886 | [NAME] | Hospitality Services | RC | 2020-10-24 | 2020-10-24 | 11:00 | 7:51 | 20:00 | 17:07 | 9:16 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:53
10886 | [NAME] | Hospitality Services | RC | 2020-10-10 | 2020-10-10 | 11:00 | 7:53 | 20:00 | 16:56 | 9:03 | 0:00 | Half Day | S10 | LA/EE | 0:00/3:04
10886 | [NAME] | Hospitality Services | RC | 2020-10-15 | 2020-10-15 | 8:00 | 7:54 | 17:00 | 17:26 | 9:32 | 0:26 | Present | S5 | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-04 | 2020-10-04 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-11 | 2020-10-11 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-21 | 2020-10-21 | 11:00 | 7:52 | 20:00 | 17:03 | 9:11 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:57
10886 | [NAME] | Hospitality Services | RC | 2020-10-01 | 2020-10-01 | 8:00 | 10:04 | 17:00 | 18:56 | 8:52 | 1:56 | Half Day | S5 | LA/EE | 2:04/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-09-29 | 2020-09-29 | 8:00 | 10:08 | 17:00 | 19:02 | 8:54 | 2:02 | Half Day | S5 | LA/EE | 2:08/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-14 | 2020-10-14 | 8:00 | 10:49 | 17:00 | 19:56 | 9:07 | 2:56 | Half Day | S5 | LA/EE | 2:49/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-22 | 2020-10-22 | 11:00 | 7:52 | 20:00 | 16:57 | 9:05 | 0:00 | Half Day | S10 | LA/EE | 0:00/3:03
10886 | [NAME] | Hospitality Services | RC | 2020-10-03 | 2020-10-03 | 8:00 | 9:53 | 17:00 | 19:03 | 9:10 | 2:03 | Half Day | S5 | LA/EE | 1:53/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-02 | 2020-10-02 | 8:00 | 0:00 | 17:00 | 0:00 | 0:00 | 0:00 | Holiday | S5 | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-09-27 | 2020-09-27 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-13 | 2020-10-13 | 8:00 | 10:58 | 17:00 | 19:58 | 9:00 | 2:58 | Half Day | S5 | LA/EE | 2:58/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-18 | 2020-10-18 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | 0:00 | Weekly Off | Weekly Off | LA/EE | 0:00/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-16 | 2020-10-16 | 8:00 | 10:33 | 17:00 | 19:59 | 9:26 | 2:59 | Half Day | S5 | LA/EE | 2:33/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-23 | 2020-10-23 | 11:00 | 7:48 | 20:00 | 17:10 | 9:22 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:50
10886 | [NAME] | Hospitality Services | RC | 2020-10-06 | 2020-10-06 | 11:00 | 7:50 | 20:00 | 17:02 | 9:12 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:58
10886 | [NAME] | Hospitality Services | RC | 2020-09-26 | 2020-09-26 | 11:00 | 7:50 | 20:00 | 16:50 | 9:00 | 0:00 | Half Day | S10 | LA/EE | 0:00/3:10
10886 | [NAME] | Hospitality Services | RC | 2020-10-20 | 2020-10-20 | 11:00 | 7:53 | 20:00 | 17:13 | 9:20 | 0:00 | Half Day | S10 | LA/EE | 0:00/2:47
10886 | [NAME] | Hospitality Services | RC | 2020-09-28 | 2020-09-28 | 8:00 | 9:56 | 17:00 | 19:02 | 9:06 | 2:02 | Half Day | S5 | LA/EE | 1:56/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-12 | 2020-10-12 | 8:00 | 10:53 | 17:00 | 19:55 | 9:02 | 2:55 | Half Day | S5 | LA/EE | 2:53/0:00
10886 | [NAME] | Hospitality Services | RC | 2020-10-05 | 2020-10-05 | 11:00 | 7:53 | 20:00 | 16:58 | 9:05 | 0:00 | Half Day | S10 | LA/EE | 0:00/3:02
IF WE DO TRASPOSE IT COMES LIKE THIS FORMAT