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

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