Spreadsheet: 88967d1288777105-converting-large-numbers-to-hours-and-minutes-totalhrs
Sheet: q_payroll_report_download

Shift Pattern | Compass | Hols | Jury | Uhol | Sick | Off Shift | On Shift | Extra Days | Worked | WORK HRS - Decimal | UK Night | Cont | Extra Hour | X HRS - Decimal | Total | USick | Paid Abs
D5 | 0 | 6 | 0 | 0 | 0 | 11 | 13 | 1 | 137:45 |  | 1 | 0 | 12:30 |  | 216:15 | 0 | 0
D3 | 0 | 3 | 0 | 0 | 0 | 12 | 16 | 0 | 169:46 |  | 3 | 0 | 0 |  | 202:46 | 0 | 0
N4 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 203:39 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D1 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 209:30 |  | 8 | 0 | 0 |  | 0 | 0 | 0
D7 | 0 | 3 | 0 | 0 | 0 | 11 | 17 | 0 | 203:00 |  | 10 | 0 | 0 |  | 236:00 | 0 | 0
N9 | 0 | 0 | 0 | 0 | 0 | 8 | 21 | 2 | 202:14 |  | 2 | 0 | 14:30 |  | 0 | 0 | 0
D4 | 0 | 0 | 0 | 0 | 0 | 10 | 19 | 2 | 207:15 |  | 2 | 0 | 24:30 |  | 0 | 0 | 0
D7 | 0 | 4 | 0 | 0 | 0 | 10 | 16 | 1 | 168:15 |  | 0 | 0 | 8:15 |  | 220:30 | 0 | 0
N1 | 0 | 1 | 0 | 0 | 0 | 10 | 18 | 2 | 176:25 |  | 0 | 0 | 23:15 |  | 210:40 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 210:30 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D3 | 0 | 7 | 0 | 0 | 0 | 12 | 12 | 0 | 128:30 |  | 4 | 0 | 0 |  | 205:30 | 0 | 0
[NAME] | 0 | 4 | 0 | 0 | 0 | 11 | 16 | 0 | 164:30 |  | 2 | 0 | 0 |  | 208:30 | 0 | 0
D3 | 0 | 7 | 0 | 0 | 0 | 11 | 12 | 1 | 142:30 |  | 5 | 0 | 6:00 |  | 225:30 | 0 | 0
N3 | 0 | 3 | 0 | 1 | 0 | 9 | 7 | 0 | 76:00 |  | 0 | 0 | 0 |  | 109:00 | 0 | 0
D2 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 203:45 |  | 0 | 0 | 0 |  | 0 | 0 | 0
N7 | 0 | 5 | 0 | 0 | 0 | 11 | 14 | 0 | 130:15 |  | 0 | 0 | 0 |  | 185:15 | 0 | 0
D5 | 0 | 5 | 0 | 0 | 0 | 12 | 14 | 0 | 156:45 |  | 1 | 0 | 0 |  | 211:45 | 0 | 0
X1 | 0 | 0 | 0 | 0 | 0 | 31 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D1 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 198:00 |  | 4 | 0 | 0 |  | 0 | 0 | 0
N1 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 202:00 |  | 0 | 0 | 0 |  | 0 | 0 | 0
N3 | 0 | 0 | 0 | 0 | 0 | 12 | 18 | 0 | 198:30 |  | 2 | 0 | 0 |  | 0 | 0 | 1
D9 | 0 | 3 | 0 | 0 | 0 | 10 | 18 | 0 | 176:15 |  | 0 | 0 | 0 |  | 205:07 | 0 | 0
D2 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 193:15 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D8 | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 239:00 |  | 4 | 0 | 0 |  | 0 | 0 | 0
D1 | 0 | 3 | 0 | 0 | 0 | 8 | 16 | 4 | 141:29 |  | 0 | 0 | 33:30 |  | 207:59 | 0 | 0
N1 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 186:51 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D9 | 0 | 4 | 0 | 0 | 0 | 10 | 17 | 0 | 201:45 |  | 1 | 0 | 0 |  | 240:15 | 0 | 0
N3 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 185:33 |  | 1 | 0 | 0 |  | 0 | 0 | 0
N7 | 0 | 5 | 0 | 0 | 0 | 11 | 15 | 0 | 159:00 |  | 0 | 0 | 0 |  | 214:00 | 0 | 0
D4 | 0 | 2 | 0 | 0 | 0 | 11 | 17 | 1 | 191:15 |  | 6 | 0 | 11:14 |  | 224:29 | 0 | 0
D7 | 0 | 10 | 0 | 0 | 0 | 10 | 10 | 1 | 120:00 |  | 6 | 0 | 9:00 |  | 239:00 | 0 | 0
D5 | 0 | 5 | 0 | 0 | 0 | 12 | 14 | 0 | 130:29 |  | 4 | 0 | 0 |  | 185:29 | 0 | 0
D5 | 0 | 8 | 0 | 0 | 0 | 12 | 11 | 0 | 118:15 |  | 1 | 0 | 0 |  | 206:15 | 0 | 0
N7 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 1 | 200:45 |  | 1 | 0 | 12:00 |  | 0 | 0 | 0
D4 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 192:00 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D4 | 0 | 0 | 0 | 0 | 0 | 13 | 17 | 1 | 204:00 |  | 0 | 0 | 12:00 |  | 0 | 0 | 0
D4 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 203:13 |  | 4 | 0 | 0 |  | 0 | 0 | 0
N2 | 0 | 5 | 0 | 0 | 0 | 11 | 14 | 1 | 160:05 |  | 0 | 0 | 10:45 |  | 225:50 | 0 | 0
D9 | 0 | 1 | 0 | 0 | 0 | 9 | 20 | 1 | 217:00 |  | 1 | 0 | 8:00 |  | 234:38 | 0 | 0
N8 | 0 | 1 | 0 | 0 | 0 | 11 | 18 | 0 | 163:30 |  | 0 | 0 | 0 |  | 174:30 | 0 | 0
D1 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 216:15 |  | 1 | 0 | 0 |  | 0 | 0 | 0
D3 | 0 | 5 | 0 | 0 | 5 | 12 | 9 | 0 | 93:45 |  | 0 | 0 | 0 |  | 203:45 | 0 | 0
D2 | 3 | 2 | 0 | 0 | 0 | 12 | 14 | 0 | 149:12 |  | 5 | 0 | 0 |  | 204:12 | 0 | 0
D6 | 0 | 0 | 0 | 0 | 0 | 9 | 20 | 2 | 232:45 |  | 3 | 0 | 22:00 |  | 0 | 0 | 0
[NAME] | 0 | 1 | 0 | 0 | 2 | 11 | 17 | 0 | 170:00 |  | 0 | 0 | 0 |  | 203:00 | 0 | 0
D3 | 0 | 0 | 0 | 0 | 0 | 10 | 19 | 2 | 181:16 |  | 0 | 0 | 18:30 |  | 0 | 0 | 0
D7 | 0 | 4 | 0 | 0 | 0 | 10 | 16 | 1 | 173:10 |  | 1 | 0 | 4:00 |  | 221:10 | 0 | 0
N2 | 0 | 0 | 0 | 0 | 0 | 10 | 19 | 2 | 187:44 |  | 1 | 0 | 21:00 |  | 0 | 0 | 0
D1 | 0 | 0 | 0 | 1 | 0 | 11 | 18 | 1 | 208:25 |  | 2 | 0 | 11:00 |  | 0 | 0 | 0
D2 | 0 | 1 | 0 | 0 | 0 | 10 | 18 | 2 | 216:30 |  | 5 | 0 | 15:30 |  | 243:00 | 0 | 0
N5 | 0 | 5 | 0 | 0 | 0 | 11 | 14 | 1 | 155:15 |  | 0 | 0 | 10:00 |  | 220:15 | 0 | 0
D7 | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 223:45 |  | 6 | 0 | 0 |  | 0 | 0 | 0
D3 | 0 | 1 | 0 | 0 | 0 | 10 | 18 | 2 | 185:55 |  | 6 | 0 | 21:55 |  | 218:50 | 0 | 0
D5 | 0 | 4 | 0 | 0 | 0 | 12 | 15 | 0 | 174:44 |  | 1 | 0 | 0 |  | 218:44 | 0 | 0
D2 | 0 | 3 | 0 | 0 | 0 | 8 | 16 | 4 | 167:20 |  | 3 | 0 | 39:50 |  | 240:10 | 0 | 0
D4 | 0 | 0 | 0 | 1 | 0 | 12 | 18 | 0 | 192:00 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D9 | 0 | 1 | 0 | 0 | 0 | 10 | 20 | 0 | 201:00 |  | 7 | 0 | 0 |  | 210:38 | 0 | 0
N9 | 0 | 0 | 0 | 0 | 0 | 8 | 21 | 2 | 207:00 |  | 0 | 0 | 12:00 |  | 0 | 0 | 0
D6 | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 208:45 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D9 | 0 | 0 | 0 | 0 | 0 | 10 | 21 | 0 | 210:15 |  | 1 | 0 | 0 |  | 0 | 0 | 0
N3 | 0 | 1 | 0 | 0 | 0 | 12 | 18 | 0 | 177:16 |  | 2 | 0 | 0 |  | 188:16 | 0 | 0
D1 | 0 | 6 | 0 | 0 | 0 | 10 | 13 | 2 | 149:46 |  | 5 | 0 | 19:01 |  | 234:47 | 0 | 0
D6 | 0 | 1 | 0 | 0 | 0 | 8 | 19 | 3 | 215:45 |  | 4 | 0 | 29:29 |  | 256:14 | 0 | 0
N8 | 0 | 2 | 0 | 0 | 0 | 11 | 18 | 0 | 186:55 |  | 2 | 0 | 0 |  | 208:55 | 0 | 0
N9 | 0 | 1 | 0 | 0 | 0 | 7 | 20 | 3 | 189:01 |  | 3 | 0 | 36:55 |  | 235:34 | 0 | 0
D5 | 0 | 5 | 0 | 0 | 0 | 12 | 14 | 0 | 165:15 |  | 3 | 0 | 0 |  | 220:15 | 0 | 0
D3 | 0 | 2 | 0 | 0 | 0 | 12 | 17 | 0 | 172:15 |  | 1 | 0 | 0 |  | 194:15 | 0 | 0
D2 | 0 | 0 | 0 | 0 | 0 | 12 | 18 | 0 | 194:30 |  | 6 | 0 | 0 |  | 0 | 0 | 0
N5 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 207:15 |  | 2 | 0 | 0 |  | 0 | 0 | 0
D7 | 0 | 3 | 0 | 0 | 0 | 7 | 17 | 4 | 175:15 |  | 1 | 0 | 31:45 |  | 240:00 | 0 | 0
N4 | 0 | 5 | 0 | 0 | 0 | 12 | 14 | 0 | 139:00 |  | 0 | 0 | 0 |  | 194:00 | 0 | 0
D8 | 0 | 0 | 0 | 0 | 0 | 9 | 20 | 2 | 216:15 |  | 5 | 0 | 19:15 |  | 0 | 0 | 0
D7 | 0 | 3 | 0 | 0 | 0 | 10 | 18 | 0 | 219:28 |  | 7 | 0 | 0 |  | 252:28 | 0 | 0
N7 | 0 | 5 | 0 | 0 | 0 | 11 | 15 | 0 | 137:30 |  | 0 | 0 | 0 |  | 192:30 | 0 | 0
N2 | 0 | 0 | 0 | 0 | 0 | 10 | 19 | 2 | 169:00 |  | 0 | 0 | 20:00 |  | 0 | 0 | 0
N5 | 0 | 2 | 0 | 0 | 0 | 11 | 17 | 1 | 176:45 |  | 1 | 0 | 10:45 |  | 209:30 | 0 | 0
D7 | 0 | 0 | 0 | 1 | 0 | 10 | 19 | 1 | 221:00 |  | 3 | 0 | 9:30 |  | 0 | 0 | 0
D9 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 1 | 191:50 |  | 4 | 0 | 8:00 |  | 0 | 0 | 0
D6 | 0 | 7 | 0 | 0 | 0 | 11 | 13 | 0 | 137:00 |  | 1 | 0 | 0 |  | 214:00 | 0 | 0
D9 | 0 | 0 | 0 | 1 | 0 | 10 | 20 | 0 | 214:00 |  | 2 | 0 | 0 |  | 0 | 0 | 0
D3 | 0 | 3 | 0 | 0 | 0 | 12 | 16 | 0 | 170:00 |  | 3 | 0 | 0 |  | 203:00 | 0 | 0
D5 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 191:30 |  | 2 | 0 | 0 |  | 0 | 0 | 0
D6 | 0 | 0 | 0 | 0 | 0 | 8 | 20 | 3 | 197:55 |  | 3 | 0 | 30:40 |  | 0 | 0 | 0
D4 | 0 | 14 | 0 | 0 | 0 | 12 | 5 | 0 | 62:45 |  | 1 | 0 | 0 |  | 216:45 | 0 | 0
N2 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 194:30 |  | 0 | 0 | 0 |  | 0 | 0 | 0
D3 | 0 | 7 | 0 | 0 | 0 | 12 | 12 | 0 | 136:30 |  | 6 | 0 | 0 |  | 213:30 | 0 | 0
D5 | 0 | 0 | 0 | 0 | 0 | 12 | 19 | 0 | 189:24 |  | 2 | 0 | 0 |  | 0 | 0 | 0
D9 | 0 | 4 | 0 | 1 | 0 | 9 | 17 | 0 | 189:15 |  | 0 | 0 | 0 |  | 227:45 | 0 | 0
D9 | 0 | 0 | 0 | 0 | 0 | 9 | 21 | 1 | 219:15 |  | 1 | 0 | 8:30 |  | 0 | 0 | 0
D8 | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 241:45 |  | 4 | 0 | 0 |  | 0 | 0 | 0
D1 | 0 | 4 | 0 | 0 | 0 | 12 | 15 | 0 | 160:30 |  | 7 | 0 | 0 |  | 204:30 | 0 | 0
D9 | 0 | 1 | 0 | 0 | 0 | 10 | 20 | 0 | 227:24 |  | 7 | 0 | 0 |  | 237:02 | 0 | 0
D3 | 0 | 2 | 0 | 0 | 0 | 12 | 17 | 0 | 158:30 |  | 2 | 0 | 0 |  | 180:30 | 0 | 0
N7 | 0 | 5 | 0 | 0 | 0 | 11 | 15 | 0 | 145:00 |  | 0 | 0 | 0 |  | 200:00 | 0 | 0
D7 | 0 | 3 | 0 | 0 | 0 | 11 | 17 | 0 | 169:20 |  | 4 | 0 | 0 |  | 202:20 | 0 | 0
N9 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 0 | 206:02 |  | 0 | 0 | 0 |  | 0 | 0 | 0
N9 | 0 | 9 | 0 | 0 | 0 | 10 | 12 | 0 | 118:40 |  | 0 | 0 | 0 |  | 205:18 | 0 | 0
D8 | 0 | 0 | 0 | 0 | 0 | 11 | 20 | 0 | 215:00 |  | 2 | 0 | 0 |  | 0 | 0 | 0
D4 | 0 | 1 | 0 | 0 | 0 | 9 | 18 | 3 | 203:35 |  | 7 | 0 | 32:00 |  | 246:35 | 0 | 0
N4 | 0 | 1 | 0 | 0 | 0 | 11 | 18 | 1 | 187:15 |  | 6 | 0 | 9:00 |  | 207:15 | 0 | 0
D4 | 0 | 1 | 0 | 0 | 0 | 10 | 18 | 2 | 158:30 |  | 1 | 0 | 18:00 |  | 187:30 | 0 | 0
N1 | 0 | 5 | 0 | 0 | 0 | 11 | 14 | 1 | 152:30 |  | 1 | 0 | 8:30 |  | 216:00 | 0 | 0
N8 | 0 | 7 | 0 | 0 | 0 | 11 | 13 | 0 | 133:00 |  | 1 | 0 | 0 |  | 210:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Total [NAME] (Decimal)