Spreadsheet: 794017d1661853370-convert-raw-data-to-date-time-text-format-time-office-data-1-
Sheet: Sheet1

SlNo. | EMPID | NAME | DEPT | DESIG | CADRE | Dt. | SHIFTID | FIRSTIN | LASTOUT | ATTID | HRSWKD | LATEIN | EARLYOUT | EXTRAHRS | TOTALHRS | SlNo.2 | EMPID2 | NAME2 | DEPT2 | DESIG2 | CADRE2 | Dt.2 | [NAME] | FIRSTIN2 | LASTOUT2 | ATTID2 | HRSWKD2 | LATEIN2 | EARLYOUT2 | EXTRAHRS2 | TOTALHRS2
1 | 113 | S.BUCHI REDDY | [NAME] | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 113
 |  |  |  |  |  | 01/07/2022 | A1 | 05:45 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 113
 |  |  |  |  |  | 02/07/2022 | A1 | 05:47 | 13:59 | 11 | 7.59 | 0.0 | 0.01 | 0.0 | 7.59 | 113
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 113
 |  |  |  |  |  | 04/07/2022 | A1 | 05:49 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 113
 |  |  |  |  |  | 05/07/2022 | A1 | 05:55 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 113
2 | 117 | GORAKH PRASAD | WELDING | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 117
 |  |  |  |  |  | 01/07/2022 | A2 | 13:42 | 22:03 | 22 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 117
 |  |  |  |  |  | 02/07/2022 | A2 | 14:23 | 22:01 | 22 | 7.37 | 0.23 | 0.0 | 0.0 | 7.37 | 117
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 117
 |  |  |  |  |  | 04/07/2022 | A2 | 13:43 | 22:02 | 22 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 117
 |  |  |  |  |  | 05/07/2022 | A2 | 13:41 | 22:03 | 22 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 117
3 | 119 | R.RAMI REDDY | CLEARING | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 119
 |  |  |  |  |  | 01/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 119
 |  |  |  |  |  | 02/07/2022 | A3 | 21:50 | 06:03 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 119
 |  |  |  |  |  | 03/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 119
 |  |  |  |  |  | 04/07/2022 | A1 | 05:47 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 119
 |  |  |  |  |  | 05/07/2022 | A1 | 05:47 | 14:02 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 119
4 | 120 | K.RAVI | STORES | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  | 01/07/2022 | A1 | 05:49 | 14:06 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 120
 |  |  |  |  |  | 02/07/2022 | A1 | 05:46 | 14:08 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 120
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 120
 |  |  |  |  |  | 04/07/2022 | A2 | 13:54 | 22:04 | 22 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 120
 |  |  |  |  |  | 05/07/2022 | A2 | 13:52 | 22:06 | 22 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 120
5 | 121 | E.SAMBASIVA RAO | COLD FORM | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 121
 |  |  |  |  |  | 01/07/2022 | A3 | 22:05 | 06:01 | 33 | 7.55 | 0.05 | 0.0 | 0.0 | 7.55 | 121
 |  |  |  |  |  | 02/07/2022 | A3 | 21:57 | 06:00 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 121
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 121
 |  |  |  |  |  | 04/07/2022 | A1 | 05:49 | 14:04 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 121
 |  |  |  |  |  | 05/07/2022 | A1 | 05:55 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 121
6 | 122 | M.SRINIVASA RAO | PAINTING | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 122
 |  |  |  |  |  | 01/07/2022 | A1 | 05:45 | 14:03 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 122
 |  |  |  |  |  | 02/07/2022 | A2 | 14:09 | 22:01 | 22 | 7.51 | 0.09 | 0.0 | 0.0 | 7.51 | 122
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 122
 |  |  |  |  |  | 04/07/2022 | A2 | 14:04 | 22:00 | 22 | 7.56 | 0.04 | 0.0 | 0.0 | 7.56 | 122
 |  |  |  |  |  | 05/07/2022 | A2 | 14:00 | 21:59 | 22 | 7.59 | 0.0 | 0.01 | 0.0 | 7.59 | 122
7 | 127 | HRIDAY NARAYAN SINGH | SHEAR | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 127
 |  |  |  |  |  | 01/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 127
 |  |  |  |  |  | 02/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 127
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 127
 |  |  |  |  |  | 04/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 127
 |  |  |  |  |  | 05/07/2022 | A |  |  | XX | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 127
8 | 128 | RADHA KRISHNA SINGH | FABRICATION | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 128
 |  |  |  |  |  | 01/07/2022 | A3 | 21:42 | 06:01 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 128
 |  |  |  |  |  | 02/07/2022 | A3 | 21:42 | 06:02 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 128
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 128
 |  |  |  |  |  | 04/07/2022 | A1 | 05:43 | 14:01 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 128
 |  |  |  |  |  | 05/07/2022 | A1 | 05:41 | 14:01 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 128
9 | 129 | V.BALA CHARY | BEAM WELDING | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 129
 |  |  |  |  |  | 01/07/2022 | A3 | 22:06 | 06:07 | 33 | 7.54 | 0.06 | 0.0 | 0.0 | 7.54 | 129
 |  |  |  |  |  | 02/07/2022 | A3 | 21:55 | 06:03 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 129
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 129
 |  |  |  |  |  | 04/07/2022 | A1 | 05:47 | 14:02 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 129
 |  |  |  |  |  | 05/07/2022 | A1 | 05:50 | 14:02 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 129
10 | 133 | P.ASHOK | COLD FORM | OPERATOR | PW |  |  |  |  |  |  |  |  |  |  | 133
 |  |  |  |  |  | 01/07/2022 | A1 | 06:01 | 13:59 | 11 | 7.58 | 0.01 | 0.01 | 0.0 | 7.58 | 133
 |  |  |  |  |  | 02/07/2022 | A1 | 05:45 | 14:00 | 11 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 133
 |  |  |  |  |  | 03/07/2022 | WW |  |  | WW | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 133
 |  |  |  |  |  | 04/07/2022 | A3 | 21:47 | 06:00 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 133
 |  |  |  |  |  | 05/07/2022 | A3 | 21:52 | 06:01 | 33 | 8.0 | 0.0 | 0.0 | 0.0 | 8.0 | 133