Spreadsheet: 747390d1631463820-calculating-time-eftotaltimecalc
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Gurantee |  |  | Break
 |  |  |  |  |  |  |  |  | 1 day, 16:00:00 |  |  | 00:30:00
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Shift 1 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 |  |  |  | 68H55
 | Shift 2 | 10:43:00 | 10:43:00 | 10:43:00 | 10:43:00 | 10:43:00 |  |  |  | 65H50
 | Shift 3 | 10:58:00 | 10:58:00 | 10:58:00 | 10:58:00 | 10:58:00 |  |  |  | 68H20
 | Shift 4 | 8:33:00 | 8:33:00 | 8:33:00 | 8:33:00 | 8:33:00 |  |  |  | 43H52
 | Shift 5 | 9:07:00 | 9:07:00 | 9:07:00 | 9:07:00 | 9:07:00 |  |  |  | [NAME]
 | Shift 6 | 9:22:00 | 9:22:00 | 9:22:00 | 9:22:00 | 9:22:00 |  |  |  | 51H35
 | Shift 7 | 10:48:00 | 10:48:00 | 10:48:00 | 10:48:00 | 10:48:00 |  |  |  | 66H15
 | Shift 8 | 8:27:00 | 8:27:00 | 8:27:00 | 8:27:00 | 8:27:00 |  |  |  | 43H45
 | Shift 9 | 8:29:00 | 8:29:00 | 8:29:00 | 8:29:00 | 8:29:00 |  |  |  | 43H45
 | Shift 10 | 10:02:00 | 10:02:00 | 10:02:00 | 10:02:00 | 10:02:00 |  |  |  | 58H40
 | Shift 11 | 10:38:00 | 10:38:00 | 10:38:00 | 10:38:00 | 10:38:00 |  |  |  | 65H25
 | Shift 12 | 10:49:00 | 10:49:00 | 10:49:00 | 10:49:00 | 10:49:00 |  |  |  | 66H20
 | Shift 13 | 8:59:00 | 8:59:00 | 8:59:00 | 8:59:00 | 8:59:00 |  |  |  | 48H25
 | Shift 14 | 9:53:00 | 9:53:00 | 9:53:00 | 9:53:00 | 9:53:00 |  |  |  | 57H55
 | Shift 15 | 9:53:00 | 9:53:00 | 9:53:00 | 9:53:00 | 9:53:00 |  |  |  | 57H55
 | Shift 16 | 9:45:00 | 9:45:00 | 9:45:00 | 9:45:00 | 9:45:00 |  |  |  | 56H00
 | Shift 17 | 9:58:00 | 9:58:00 | 9:58:00 | 9:58:00 | 9:58:00 |  |  |  | 58H20
 | Shift 19 | 8:24:00 | 8:24:00 | 8:24:00 | 8:24:00 | 8:24:00 |  |  |  | 43H45
 | Shift 20 | 9:08:00 | 9:08:00 | 9:08:00 | 9:08:00 | 9:08:00 |  |  |  | 50H25
 | Shift 21 | 7:53:00 | 7:53:00 | 7:53:00 | 7:53:00 | 7:53:00 |  |  |  | 40H35
 | Shift 22 | 8:41:00 | 8:41:00 | 8:41:00 | 8:41:00 | 8:41:00 |  |  |  | 45H40
 | Shift 23 | 8:02:00 | 8:02:00 | 8:02:00 | 8:02:00 | 8:02:00 |  |  |  | 40H05
 | Shift 24 | 10:10:00 | 10:10:00 | 10:10:00 | 10:10:00 | 10:10:00 |  |  |  | 60H35
 | Shift 25 | 8:32:00 | 8:32:00 | 8:32:00 | 8:32:00 | 8:32:00 |  |  |  | 43H50
 | Shift 26 | 8:37:00 | 8:37:00 | 8:37:00 | 8:37:00 | 8:37:00 |  |  |  | 44H05
 | Shift 27 | 7:59:00 | 7:59:00 | 7:59:00 | 7:59:00 | 7:59:00 |  |  |  | 40H05
 | Shift 28 | 11:33:00 | 11:33:00 | 11:33:00 | 11:33:00 | 11:33:00 |  |  |  | 73H45
 | Shift 29 | 10:54:00 | 10:54:00 | 10:54:00 | 10:54:00 | 10:54:00 |  |  |  | 68H00
 | Shift 30 | 10:21:00 | 10:21:00 | 10:21:00 | 10:21:00 | 10:21:00 |  |  |  | 61H30
 | Shift 31 | 7:34:00 | 7:34:00 | 7:34:00 | 7:34:00 | 7:34:00 |  |  |  | 40H00
 | Shift 32 | 8:40:00 | 8:40:00 | 8:40:00 | 8:40:00 | 8:40:00 |  |  |  | 45H40
 | Shift 33 | 9:13:00 | 9:13:00 | 9:13:00 | 9:13:00 | 9:13:00 |  |  |  | 50H50
 | Shift 34 | 8:51:00 | 8:51:00 | 8:51:00 | 8:51:00 | 8:51:00 |  |  |  | 46H30
 | Shift 35 | 9:26:00 | 9:26:00 | 9:26:00 | 9:26:00 | 9:26:00 |  |  |  | 53H10
 | Shift 36 | 9:16:00 | 9:16:00 | 9:16:00 | 9:16:00 | 9:16:00 |  |  |  | 51H05
 | Shift 37 | 9:26:00 | 9:26:00 | 9:26:00 | 9:26:00 | 9:26:00 |  |  |  | 53H10
 | Shift 38 | 8:27:00 | 8:27:00 | 8:27:00 | 8:27:00 | 8:27:00 |  |  |  | 43H45
 | Shift 39 | 9:24:00 | 9:24:00 | 9:24:00 | 9:24:00 | 9:24:00 |  |  |  | 53H00
 | Shift 40 | 7:58:00 | 7:58:00 | 7:58:00 | 7:58:00 | 7:58:00 |  |  |  | 40H10