Spreadsheet: 870838d1717283782-graphing-and-analyzing-time-per-department-monthly-oh-labor-analysis
Sheet: Sheet1

 |  | Jan 22 | Feb 22 | Mar 22 | Apr 22 | May 22 | Jun 22 | Jul 22 | Aug 22 | Sep 22 | Oct 22 | Nov 22 | Dec 22 | Jan 23 | Feb 23 | Mar 23 | Apr 23 | May 23 | Jun 23 | Jul 23 | Aug 23 | Sep 23 | Oct 23 | Nov 23 | Dec 23 | Jan 24 | Feb 24 | Mar 24 | Apr 24 | TOTAL
 | 100/FABRIC | 32 days, 9:10:00 | 36 days, 3:40:00 | 1,379:47 | 32 days, 16:46:00 | 37 days, 17:09:00 | 30 days, 16:44:00 | 22 days, 5:37:00 | 28 days, 15:06:00 | 9 days, 4:33:00 | 13 days, 21:18:00 | 9 days, 12:20:00 | 14 days, 7:49:00 | 23 days, 19:16:00 | 22 days, 18:05:00 | 19 days, 18:02:00 | 31 days, 10:02:00 | 34 days, 16:13:00 | 16 days, 5:53:00 | 19 days, 6:28:00 | 19 days, 11:25:00 | 28 days, 20:42:00 | 34 days, 9:22:00 | 24 days, 2:31:00 | 16 days, 7:14:00 | 15 days, 17:19:00 | 10 days, 12:24:00 | 2 days, 4:32:00 | 15 days, 19:19:00
 | 200/METAL | 7 days, 20:36:00 | 6 days, 9:20:00 | 7 days, 3:07:00 | 8 days, 7:33:00 | 5 days, 11:27:00 | 4 days, 21:10:00 | 4 days, 22:23:00 | 2 days, 13:41:00 | 2 days, 5:52:00 | 2 days, 17:23:00 | 1 day, 7:05:00 | 1 day, 23:58:00 | 1 day, 11:04:00 | 2 days, 10:32:00 | 4 days, 0:42:00 | 2 days, 3:13:00 | 5 days, 6:56:00 | 1 day, 20:41:00 | 5 days, 15:30:00 | 2 days, 21:23:00 | 16:03:00 | 6 days, 17:44:00 | 3 days, 18:14:00 | 4 days, 1:49:00 | 4 days, 10:16:00 | 6:30:00 | 10:50:00 | 1 day, 14:44:00
 | 210/METAL-B | 1 day, 13:38:00 | 3 days, 2:42:00 | 7 days, 6:55:00 | 3 days, 11:29:00 | 3 days, 21:28:00 | 4 days, 1:26:00 | 4 days, 11:10:00 | 3 days, 4:30:00 | 2 days, 2:52:00 | 4 days, 14:17:00 | 1 day, 17:28:00 | 10:58:00 | 4 days, 21:36:00 | 2 days, 10:40:00 | 2 days, 8:14:00 | 1 day, 10:17:00 | 2:12:00 | 15:55:00 | 11:52:00 | 2 days, 22:22:00 | 1 day, 11:13:00 | 3 days, 7:44:00 | 3 days, 4:38:00 | 2:14:00 | 4 days, 8:02:00 | 17:12:00 | 0:00:00 | 5:48:00
 | 230/METAL-Br | 1 day, 19:05:00 | 2 days, 13:21:00 | 7 days, 12:58:00 | 6 days, 1:56:00 | 5 days, 14:19:00 | 2 days, 23:18:00 | 5 days, 0:34:00 | 2 days, 4:01:00 | 1 day, 3:01:00 | 2 days, 18:03:00 | 1 day, 14:41:00 | 1 day, 2:44:00 | 20:41:00 | 2 days, 9:54:00 | 2 days, 16:17:00 | 6 days, 23:25:00 | 18 days, 1:34:00 | 11 days, 3:16:00 | 2 days, 9:50:00 | 2 days, 2:34:00 | 1 day, 11:45:00 | 3 days, 4:05:00 | 4 days, 13:41:00 | 2 days, 10:31:00 | 5 days, 20:49:00 | 18:17:00 | 19:23:00 | 18:30:00
 | 300/F&W | 31 days, 3:42:00 | 36 days, 2:36:00 | 27 days, 3:07:00 | 30 days, 21:07:00 | 34 days, 3:54:00 | 17 days, 8:37:00 | 26 days, 13:11:00 | 35 days, 15:31:00 | 14 days, 5:30:00 | 13 days, 8:21:00 | 22 days, 12:02:00 | 14 days, 1:23:00 | 22 days, 12:49:00 | 34 days, 18:20:00 | 12 days, 22:38:00 | 20 days, 3:47:00 | 25 days, 3:43:00 | 23 days, 13:41:00 | 27 days, 22:10:00 | 31 days, 15:25:00 | 31 days, 21:55:00 | 10 days, 15:59:00 | 21 days, 17:01:00 | 10 days, 13:43:00 | 10 days, 23:35:00 | 7 days, 17:37:00 | 9 days, 19:21:00 | 9 days, 20:20:00
 | 400/S&P | 5 days, 0:30:00 | 4 days, 8:37:00 | 13 days, 12:14:00 | 6 days, 19:49:00 | 11 days, 3:28:00 | 7 days, 11:01:00 | 6 days, 17:14:00 | 5 days, 15:46:00 | 1 day, 10:14:00 | 1 day, 4:31:00 | 3 days, 17:07:00 | 2 days, 4:26:00 | 6 days, 21:47:00 | 1 day, 13:56:00 | 2 days, 14:04:00 | 3 days, 12:27:00 | 10:15:00 | 1 day, 22:46:00 | 3 days, 7:56:00 | 3 days, 14:46:00 | 3 days, 1:00:00 | 1 day, 19:58:00 | 2 days, 19:21:00 | 1 day, 15:05:00 | 1 day, 18:47:00 | 6:35:00 | 1 day, 10:56:00 | 2 days, 3:03:00
 | 500/Assembly | 2 days, 8:25:00 | 4 days, 9:23:00 | 14 days, 0:37:00 | 7 days, 3:41:00 | 2 days, 10:21:00 | 17 days, 14:03:00 | 6 days, 0:02:00 | 10 days, 1:34:00 | 6 days, 16:37:00 | 17:23:00 | 2 days, 12:36:00 | 3 days, 12:45:00 | 9 days, 6:05:00 | 4 days, 18:35:00 | 3 days, 8:42:00 | 4 days, 17:49:00 | 0:45:00 | 2:59:00 | 2 days, 3:21:00 | 16:38:00 | 1 day, 2:14:00 | 7 days, 8:37:00 | 4 days, 17:55:00 | 5 days, 7:13:00 | 2 days, 7:35:00 | 0:00:00 | 2 days, 4:08:00 | 21:14:00
 | 600/Shipping | 7:00:00 | 22:37:00 | 3 days, 18:58:00 | 1 day, 2:19:00 | 1 day, 5:14:00 | 3 days, 19:50:00 | 1 day, 8:34:00 | 5:54:00 | 2 days, 11:05:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 5:42:00 | 3 days, 3:49:00 | 0:00:00 | 8:00:00 | 0:00:00 | 12:05:00 | 2:01:00 | 0:00:00 | 0:00:00 | 0:00:00 | 2:38:00 | 0:00:00 | 8:00:00 | 0:00:00 | 0:00:00
 | 709/REWORK | 0:00:00 | 5:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 800/OH | 11 days, 11:10:00 | 2 days, 2:51:00 | 2:11:00 | 1:05:00 | 0:00:00 | 0:00:00 | 2:38:00 | 12:06:00 | 9:46:00 | 0:00:00 | 3 days, 21:57:00 | 5 days, 9:47:00 | 7:10:00 | 0:35:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 1 day, 17:56:00 | 0:00:00 | 1:59:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 801/Cleaning | 0:00:00 | 5:23:00 | 1:06:00 | 5:11:00 | 5:18:00 | 2 days, 12:38:00 | 4 days, 13:46:00 | 7 days, 7:26:00 | 19 days, 1:00:00 | 29 days, 12:39:00 | 34 days, 0:39:00 | 9 days, 2:09:00 | 13 days, 4:03:00 | 6 days, 9:21:00 | 7 days, 1:31:00 | 1 day, 3:20:00 | 6:30:00 | 1:05:00 | 8:39:00 | 12:24:00 | 5:26:00 | 6 days, 7:08:00 | 2 days, 22:03:00 | 3 days, 14:00:00 | 23 days, 5:15:00 | 37 days, 17:48:00 | 37 days, 13:18:00 | 25 days, 18:21:00
 | 802/Maint | 0:00:00 | 7:34:00 | 4:35:00 | 2:25:00 | 17:30:00 | 4 days, 15:55:00 | 1 day, 18:39:00 | 1 day, 6:33:00 | 7 days, 13:19:00 | 7:52:00 | 7:39:00 | 20:00:00 | 1 day, 13:23:00 | 9:18:00 | 1 day, 0:58:00 | 4:30:00 | 1 day, 4:14:00 | 2 days, 4:12:00 | 1 day, 15:04:00 | 1 day, 18:44:00 | 1 day, 14:56:00 | 3 days, 13:57:00 | 13:21:00 | 9 days, 2:46:00 | 21:12:00 | 3:37:00 | 0:00:00 | 14:02:00
 | 803/Training | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 19:20:00 | 1 day, 3:53:00 | 0:00:00 | 0:00:00 | 4:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 23:45:00 | 0:00:00 | 1:38:00 | 0:00:00 | 0:00:00 | 1 day, 17:34:00 | 1 day, 7:38:00 | 8:25:00 | 20:34:00 | 0:00:00 | 0:00:00 | 12:38:00
 | 805/Bachmann | 0:00:00 | 3:27:00 | 5:51:00 | 1:19:00 | 12:13:00 | 13:56:00 | 5:48:00 | 20:28:00 | 0:20:00 | 0:00:00 | 2:01:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 830/Holiday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 4 days, 8:00:00 | 0:00:00 | 3 days, 16:00:00 | 0:00:00 | 1 day, 16:00:00 | 0:00:00 | 9 days, 8:00:00 | 0:00:00 | 4 days, 8:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 4 days, 16:00:00 | 0:00:00 | 2 days, 16:00:00 | 0:00:00 | 3 days, 0:00:00 | 0:00:00 | 0:00:00 | 15 days, 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 840/Vacation | 0:00:00 | 13:00:00 | 1 day, 5:00:00 | 8:00:00 | 0:00:00 | 0:00:00 | 1 day, 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 850/Sick | 0:00:00 | 2 days, 22:42:00 | 1 day, 14:00:00 | 1 day, 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 880/PTO | 0:00:00 | 0:00:00 | 0:00:00 | 16:00:00 | 2 days, 15:00:00 | 2 days, 0:00:00 | 3 days, 8:00:00 | 2 days, 8:46:00 | 6:28:00 | 0:00:00 | 2 days, 8:34:00 | 3 days, 18:02:00 | 1 day, 16:01:00 | 0:00:00 | 0:00:00 | 0:00:00 | 1 day, 15:19:00 | 16:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | 890/Shipping Misc | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 2 days, 4:39:00 | 4 days, 1:25:00 | 14:18:00 | 4 days, 7:25:00 | 6 days, 6:27:00 | 6 days, 21:07:00 | 6 days, 4:28:00 | 5 days, 3:32:00 | 11 days, 0:01:00 | 10 days, 12:05:00 | 7 days, 11:53:00 | 12 days, 2:54:00 | 13 days, 5:27:00 | 10 days, 6:19:00 | 6 days, 17:45:00 | 3 days, 1:00:00 | 10 days, 15:00:00 | 19 days, 19:18:00 | 5 days, 1:34:00 | 1 day, 2:02:00 | 7:57:00 | 8:00:00 | 0:00:00 | 7:59:00
 | 999-WarrantyJob | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 8 days, 13:10:00 | 14 days, 5:56:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | OH-Workers Comp Claim | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 3 days, 2:30:00 | 0:00:00 | 4:38:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
 | No item assigned | 16:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 8:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
TOTAL