Spreadsheet: 877630d1724424069-comparing-time-in-two-different-columns-for-a-job-tlmayo1965-job-hours-from-mon-jan-01-24-to-sun-aug-25-24-tms
Sheet: Table 1

 | Job Number |  |  | Total Hours |  |  |  | Job Number | Total Hours |  |  | Job Number | Total Hours E | Total Hours J | Comp-arison
AIR TECHNIQUES | 244138 | 28:00 |  |  |  | Air Techniques:24-4138 |  |  | 1 day, 4:00:00
Airco-Angle Frames | 244174 | 49:52 |  |  |  | AirCo Industrial Service:23-4047 |  |  | 4:37:00 |  |  | 244174 | 2 days, 1:52:00 | 2 days, 1:52:00
AIRCO | 244108 | 4:34 |  |  |  | AirCo Industrial Service:23-4089 |  |  | 5 days, 23:40:00 |  |  | 244108 | 4:34:00 | 4:34:00
AIRCO | 244142 | 11:38 |  |  |  | AirCo Industrial Service:24-4095 |  |  | 8:03:00 |  |  | 244142 | 11:38:00 | 11:38:00
AIRCO | 244152 | 67:23 |  |  |  | AirCo Industrial Service:24-4100 |  |  | 8:04:00 |  |  | 244152 | 2 days, 19:23:00 | 2 days, 19:23:00
AIRCO | 234047 | 4:37 |  |  |  | AirCo Industrial Service:24-4103 |  |  | 9:13:00 |  |  | 234047 | 4:37:00 | 4:37:00
AIRCO | 234089 | 143:40 |  |  |  | AirCo Industrial Service:24-4108 |  |  | 4:34:00 |  |  | 234089 | 5 days, 23:40:00 | 5 days, 23:40:00
AIRCO | 244095 | 8:03 |  |  |  | AirCo Industrial Service:24-4142 |  |  | 11:38:00 |  |  | 244095 | 8:03:00 | 8:03:00
AIRCO | 244100 | 8:04 |  |  |  | AirCo Industrial Service:24-4152 |  |  | 2 days, 19:23:00 |  |  | 244100 | 8:04:00 | 8:04:00
AIRCO | 244103 | 9:13 |  |  |  | AirCo Industrial Service:24-4174 |  |  | 2 days, 1:52:00 |  |  | 244103 | 9:13:00 | 9:13:00
AMERICAN ELECTRIC | 234018 | 0:55 |  |  |  | American Electric Power:23-4018 |  |  | 0:55:00 |  |  | 234018 | 0:55:00 | 0:55:00
Bachmann L&A Metal Pillows | 244211 | 7:35 | 0:25 |  |  | Bachmann Industries Inc:23-4081 |  |  | 13 days, 10:33:00 |  |  | 244211 | 8:00:00 | 8:00:00
Bachmann NB Powerseals | 244223 | 15:31 |  |  |  | Bachmann Industries Inc:23-4086 |  |  | 1 day, 18:23:00 |  |  | 244223 | 15:31:00 | not found
Bachmann Qingdoa Bachmann | 244176 | 317:15 |  |  |  | Bachmann Industries Inc:23-4087 |  |  | 1 day, 1:30:00 |  |  | 244176 | 13 days, 5:15:00 | 19 days, 8:46:00
Bachmann Qingdoa Bachmann | 244175 | 269:45 |  |  |  | Bachmann Industries Inc:24-4102 |  |  | 1 day, 6:02:00 |  |  | 244175 | 11 days, 5:45:00 | 1 day, 10:48:00
Bachmann-ADNOC | 244192 | 40:13 |  |  |  | Bachmann Industries Inc:24-4106 |  |  | 7:02:00 |  |  | 244192 | 1 day, 16:13:00 | 1 day, 16:13:00
Bachmann-Aspen | 244177 | 27:23 |  |  |  | Bachmann Industries Inc:24-4107 |  |  | 6:53:00 |  |  | 244177 | 1 day, 3:23:00 | 2 days, 4:02:00
Bachmann-Energy West | 244181 | 112:03 |  |  |  | Bachmann Industries Inc:24-4109 |  |  | 3 days, 7:51:00 |  |  | 244181 | 4 days, 16:03:00 | 4 days, 16:03:00
Bachmann-L&A Pillow | 244209 | 7:44 |  |  |  | Bachmann Industries Inc:24-4114 |  |  | 9 days, 7:37:00 |  |  | 244209 | 7:44:00 | 7:44:00
Bachmann-Qatar | 244194 | 17:59 |  |  |  | Bachmann Industries Inc:24-4134 |  |  | 5:25:00 |  |  | 244194 | 17:59:00 | 17:59:00
Bachmann-QBD China | 244220 | 0:40 |  |  |  | Bachmann Industries Inc:24-4144 |  |  | 4 days, 16:23:00 |  |  | 244220 | 0:40:00 | not found
BACHMANN | 244169 | 13:47 |  |  |  | Bachmann Industries Inc:24-4148 |  |  | 22:19:00 |  |  | 244169 | 13:47:00 | 13:47:00
BACHMANN | 244161 | 94:28 |  |  |  | Bachmann Industries Inc:24-4155 |  |  | 4:00:00 |  |  | 244161 | 3 days, 22:28:00 | 3 days, 22:28:00
BACHMANN | 244170 | 82:02 | 0:59 |  |  | Bachmann Industries Inc:24-4157 |  |  | 20:04:00 |  |  | 244170 | 3 days, 11:01:00 | 3 days, 11:01:00
Bachmann | 244173 | 5:31 |  |  |  | Bachmann Industries Inc:24-4160 |  |  | 3 days, 8:03:00 |  |  | 244173 | 5:31:00 | 5:31:00
BACHMANN | 244160 | 111:36 |  |  |  | Bachmann Industries Inc:24-4161 |  |  | 3 days, 22:28:00 |  |  | 244160 | 4 days, 15:36:00 | 3 days, 8:03:00
BACHMANN | 244106 | 7:02 |  |  |  | Bachmann Industries Inc:24-4169 |  |  | 13:47:00 |  |  | 244106 | 7:02:00 | 7:02:00
BACHMANN | 244107 | 5:04 |  |  |  | Bachmann Industries Inc:24-4170 |  |  | 3 days, 11:01:00 |  |  | 244107 | 5:04:00 | 6:53:00
BACHMANN | 244109 | 79:51 |  |  |  | Bachmann Industries Inc:24-4173 |  |  | 5:31:00 |  |  | 244109 | 3 days, 7:51:00 | 3 days, 7:51:00
BACHMANN | 244102 | 30:02 |  |  |  | Bachmann Industries Inc:24-4175 |  |  | 1 day, 10:48:00 |  |  | 244102 | 1 day, 6:02:00 | 1 day, 6:02:00
BACHMANN | 234081 | 322:33 |  |  |  | Bachmann Industries Inc:24-4176 |  |  | 19 days, 8:46:00 |  |  | 234081 | 13 days, 10:33:00 | 13 days, 10:33:00
BACHMANN | 234086 | 42:23 |  |  |  | Bachmann Industries Inc:24-4177 |  |  | 2 days, 4:02:00 |  |  | 234086 | 1 day, 18:23:00 | 1 day, 18:23:00
BACHMANN | 234087 | 25:30 |  |  |  | Bachmann Industries Inc:24-4181 |  |  | 4 days, 16:03:00 |  |  | 234087 | 1 day, 1:30:00 | 1 day, 1:30:00
BACHMANN | 244148 | 22:19 |  |  |  | Bachmann Industries Inc:24-4192 |  |  | 1 day, 16:13:00 |  |  | 244148 | 22:19:00 | 22:19:00
BACHMANN | 244155 | 4:00 |  |  |  | Bachmann Industries Inc:24-4194 |  |  | 17:59:00 |  |  | 244155 | 4:00:00 | 4:00:00
BACHMANN | 244157 | 29:02 | 1:39 |  |  | Bachmann Industries Inc:24-4209 |  |  | 7:44:00 |  |  | 244157 | 1 day, 6:41:00 | 20:04:00
BACHMANN | 244144 | 112:23 |  |  |  | Bachmann Industries Inc:24-4211 |  |  | 8:00:00 |  |  | 244144 | 4 days, 16:23:00 | 4 days, 16:23:00
BACHMANN | 244113 | 2:18 |  |  |  | [NAME] |  |  | 18:56:00 |  |  | 244113 | 2:18:00 | not found
BACHMANN | 244114 | 216:18 |  |  |  | [NAME] |  |  | 3 days, 12:57:00 |  |  | 244114 | 9 days, 0:18:00 | 9 days, 7:37:00
BACHMANN | 244134 | 5:25 |  |  |  | [NAME] |  |  | 9:58:00 |  |  | 244134 | 5:25:00 | 5:25:00
[NAME] | 244198 | 59:03 |  |  |  | [NAME] |  |  | 3 days, 3:33:00 |  |  | 244198 | 2 days, 11:03:00 | 2 days, 11:03:00
BARRON FAN | 244135 | 82:13 |  |  |  | [NAME] |  |  | 1 day, 9:05:00 |  |  | 244135 | 3 days, 10:13:00 | 3 days, 10:13:00
BARRON FAN | 244137 | 3:37 |  |  |  | [NAME] |  |  | 4:42:00 |  |  | 244137 | 3:37:00 | 3:37:00
BARRON FAN | 244139 | 6:29 |  |  |  | [NAME] |  |  | 10:44:00 |  |  | 244139 | 6:29:00 | 6:29:00
BARRON FAN | 244154 | 23:00 | 0:32 |  |  | [NAME] |  |  | 3 days, 10:13:00 |  |  | 244154 | 23:32:00 | 23:32:00
[NAME] | 244185 | 558:39 | 1:06 |  |  | [NAME] |  |  | 3:37:00 |  |  | 244185 | 23 days, 7:45:00 | 23 days, 11:11:00
BARRON FAN | 244131 | 10:44 |  |  |  | [NAME] |  |  | 6:29:00 |  |  | 244131 | 10:44:00 | 10:44:00
BARRON FAN | 244096 | 8:34 |  |  |  | [NAME] |  |  | 23:32:00 |  |  | 244096 | 8:34:00 | 9:58:00
BARRON FAN | 244094 | 84:50 | 0:07 |  |  | [NAME] |  |  | 23 days, 11:11:00 |  |  | 244094 | 3 days, 12:57:00 | 3 days, 12:57:00
BARRON FAN | 234092 | 18:56 |  |  |  | [NAME] |  |  | 2 days, 11:03:00 |  |  | 234092 | 18:56:00 | 18:56:00
BARRON FAN | 244127 | 4:42 |  |  |  | Basin Electric Power Cooperative:24-4206 |  |  | 2 days, 13:58:00 |  |  | 244127 | 4:42:00 | 4:42:00
BARRON FAN | 244123 | 33:05 |  |  |  | Cargill LTD:24-4116 |  |  | 8:47:00 |  |  | 244123 | 1 day, 9:05:00 | 1 day, 9:05:00
BARRON FAN | 244117 | 75:33 |  |  |  | CleaverBrooks:24-4197 |  |  | 27 days, 7:45:00 |  |  | 244117 | 3 days, 3:33:00 | 3 days, 3:33:00
Basin Electric EJ | 244206 | 76:39 |  |  |  | Cleveland Cliffs Steel Corporation:23-4064 |  |  | 1 day, 13:41:00 |  |  | 244206 | 3 days, 4:39:00 | 2 days, 13:58:00
CARGILL | 244116 | 8:55 |  |  |  | Damper & Controls Systems LLC:23-4085 |  |  | 1 day, 8:52:00 |  |  | 244116 | 8:55:00 | 8:47:00
Cleaver Brooks-EJ Assembly | 244197 | 660:38 | 0:54 |  |  | Damper & Controls Systems LLC:24-4121 |  |  | 1 day, 6:47:00 |  |  | 244197 | 27 days, 13:32:00 | 27 days, 7:45:00
CLEVELAND CLIFFS | 234064 | 37:41 |  |  |  | Damper & Controls Systems LLC:24-4125 |  |  | 9:43:00 |  |  | 234064 | 1 day, 13:41:00 | 1 day, 13:41:00
Damper and Control Belt | 244207 | 9:08 |  |  |  | Damper & Controls Systems LLC:24-4133 |  |  | 7:59:00 |  |  | 244207 | 9:08:00 | 9:08:00
Damper and Control EJ | 244208 | 24:44 |  |  |  | Damper & Controls Systems LLC:24-4141 |  |  | 12:35:00 |  |  | 244208 | 1 day, 0:44:00 | 21:41:00
DAMPER AND CONTROL REWO | 994121 | 22:49 |  |  |  | Damper & Controls Systems LLC:24-4171 |  |  | 8:11:00 |  |  | 994121 | 22:49:00 | not found
DAMPER AND CONTROL | 244171 | 8:11 |  |  |  | Damper & Controls Systems LLC:24-4203 |  |  | 13:34:00 |  |  | 244171 | 8:11:00 | 8:11:00
DAMPER AND CONTROL | 244125 | 9:43 |  |  |  | Damper & Controls Systems LLC:24-4207 |  |  | 9:08:00 |  |  | 244125 | 9:43:00 | 9:43:00
DAMPER AND CONTROL | 244133 | 7:59 |  |  |  | Damper & Controls Systems LLC:24-4208 |  |  | 21:41:00 |  |  | 244133 | 7:59:00 | 7:59:00
DAMPER AND CONTROL | 244141 | 12:35 |  |  |  | Duke Energy:24-4120 |  |  | 15 days, 23:42:00 |  |  | 244141 | 12:35:00 | 12:35:00
DAMPER AND CONTROLE | 234085 | 32:52 |  |  |  | G Squared Engineered Products:24-4119 |  |  | 1:00:00 |  |  | 234085 | 1 day, 8:52:00 | 1 day, 8:52:00
[NAME] | 244203 | 13:34 |  |  |  | G Squared Engineered Products:24-4156 |  |  | 18:18:00 |  |  | 244203 | 13:34:00 | 13:34:00
DAMPER SYSTEMS | 244121 | 30:47 |  |  |  | G Squared Engineered Products:24-4184 |  |  | 2 days, 9:26:00 |  |  | 244121 | 1 day, 6:47:00 | 1 day, 6:47:00
DUKE ENERGY | 244120 | 379:13 | 4:29 |  |  | Get Pro Industrial:24-4149 |  |  | 16:34:00 |  |  | 244120 | 15 days, 23:42:00 | 15 days, 23:42:00
ERIKS | 244124 | 9:14 |  |  |  | Indorama Ventures Xylenes:24-4136 |  |  | 2 days, 11:46:00 |  |  | 244124 | 9:14:00 | 9:14:00
ERIKS | 244111 | 4:55 |  |  |  | L & M Industrial Contracting, Inc.:24-4110 |  |  | 3:46:00 |  |  | 244111 | 4:55:00 | 4:55:00
G Squared | 244184 | 81:31 | 0:15 |  |  | L & M Industrial Contracting, Inc.:24-4147 |  |  | 3 days, 22:48:00 |  |  | 244184 | 3 days, 9:46:00 | 2 days, 9:26:00
G SQUARED | 244156 | 18:18 |  |  |  | L & M Industrial Contracting, Inc.:24-4166 |  |  | 1 day, 0:27:00 |  |  | 244156 | 18:18:00 | 18:18:00
G SQUARED | 244119 | 1:00 |  |  |  | Levenseat Renewable Energy:24-4189 |  |  | 7:51:00 |  |  | 244119 | 1:00:00 | 1:00:00
GETPRO | 244149 | 16:34 |  |  |  | LGG Industrial (Eriks):24-4111 |  |  | 4:55:00 |  |  | 244149 | 16:34:00 | 16:34:00
INDORAMA VENTURES | 244136 | 59:46 |  |  |  | LGG Industrial (Eriks):24-4124 |  |  | 9:14:00 |  |  | 244136 | 2 days, 11:46:00 | 2 days, 11:46:00
L&M | 244166 | 24:27 |  |  |  | LGG Industrial (Eriks):24-4187 |  |  | 0:49:00 |  |  | 244166 | 1 day, 0:27:00 | 1 day, 0:27:00
L&M | 244147 | 84:11 |  |  |  | LGG Industrial (Eriks):24-4196 |  |  | 3:40:00 |  |  | 244147 | 3 days, 12:11:00 | 3 days, 22:48:00
L&M | 244110 | 3:46 |  |  |  | LGG Industrial (Eriks):24-4204 |  |  | 7:29:00 |  |  | 244110 | 3:46:00 | 3:46:00
Levenseat Renewable Energy | 244189 | 7:51 |  |  |  | Magnatex Pumps:23-4076 |  |  | 0:40:00 |  |  | 244189 | 7:51:00 | 7:51:00
LGG Boot Type EJ | 244204 | 7:25 |  |  |  | Mitsubishi Power:24-4162 |  |  | 1 day, 22:58:00 |  |  | 244204 | 7:25:00 | 7:29:00
LGG Industrial-EJ | 244196 | 3:40 |  |  |  | Monarch Welding:24-4164 |  |  | 12:11:00 |  |  | 244196 | 3:40:00 | 3:40:00
LGG-NCS | 244187 | 0:49 |  |  |  | Motion:24-4165 |  |  | 0:25:00 |  |  | 244187 | 0:49:00 | 0:49:00
MAGNATEX PUMPS | 234076 | 0:40 |  |  |  | Motion:24-4188 |  |  | 2 days, 17:50:00 |  |  | 234076 | 0:40:00 | 0:40:00
Mitsubishi warranty | 993823 | 7:54 |  |  |  | National Grid Generation:24-4153 |  |  | 2:12:00 |  |  | 993823 | 7:54:00 | not found
MITSUBISHI | 244162 | 46:58 |  |  |  | Orion Engineered Carbons:24-4172 |  |  | 1 day, 22:32:00 |  |  | 244162 | 1 day, 22:58:00 | 1 day, 22:58:00
MONARCH WELDING | 244164 | 12:11 |  |  |  | St. Mary's Cement:23-4019 |  |  | 8:00:00 |  |  | 244164 | 12:11:00 | 12:11:00
MOTION IND. | 244165 | 0:25 |  |  |  | St. Mary's Cement:24-4158 |  |  | 19:13:00 |  |  | 244165 | 0:25:00 | 0:25:00
Motion-NCS | 244188 | 65:50 |  |  |  | St. Mary's Cement:24-4159 |  |  | 13:35:00 |  |  | 244188 | 2 days, 17:50:00 | 2 days, 17:50:00
NATIONAL GRID | 244153 | 2:12 |  |  |  | St. Mary's Cement:24-4210 |  |  | 13:56:00 |  |  | 244153 | 2:12:00 | 2:12:00
Orion-NHS-1500 Belt and Pillow | 244172 | 46:32 |  |  |  | Storm Technologies:24-4186 |  |  | 9:40:00 |  |  | 244172 | 1 day, 22:32:00 | 1 day, 22:32:00
[NAME] Damper | 244210 | 43:12 |  |  |  | Technos:24-4098 |  |  | 14:19:00 |  |  | 244210 | 1 day, 19:12:00 | 13:56:00
ST MARYS | 244159 | 13:35 |  |  |  | Technos:24-4112 |  |  | 1:13:00 |  |  | 244159 | 13:35:00 | 13:35:00
ST MARYS | 244158 | 19:13 |  |  |  | Technos:24-4126 |  |  | 2:01:00 |  |  | 244158 | 19:13:00 | 19:13:00
St. Mary's Warranty | 994019 | 12:10 |  |  |  | Technos:24-4145 |  |  | 1 day, 13:08:00 |  |  | 994019 | 12:10:00 | not found
ST. MARYS | 234019 | 8:00 |  |  |  | Technos:24-4190 |  |  | 0:20:00 |  |  | 234019 | 8:00:00 | 8:00:00
Storm Technologies | 244186 | 9:40 |  |  |  | Technos:24-4213 |  |  | 17:12:00 |  |  | 244186 | 9:40:00 | 9:40:00
Technos Fan | 244213 | 29:45 |  |  |  | Technos:24-4215 |  |  | 1:43:00 |  |  | 244213 | 1 day, 5:45:00 | 17:12:00
Technos Fan | 244190 | 0:20 |  |  |  | Valmet Inc:23-4077 |  |  | 10 days, 23:04:00 |  |  | 244190 | 0:20:00 | 0:20:00
Technos NCS 550 | 244215 | 1:43 |  |  |  | [NAME] |  |  | 4 days, 3:01:00 |  |  | 244215 | 1:43:00 | 1:43:00
TECHNOS | 244126 | 2:01 |  |  |  | [NAME] |  |  | 16 days, 8:05:00 |  |  | 244126 | 2:01:00 | 2:01:00
TECHNOS | 244098 | 14:19 |  |  |  |  |  |  |  |  |  | 244098 | 14:19:00 | 14:19:00
TECHNOS | 244112 | 1:13 |  |  |  |  |  |  |  |  |  | 244112 | 1:13:00 | 1:13:00
TECHNOS | 244145 | 37:08 |  |  |  |  |  |  |  |  |  | 244145 | 1 day, 13:08:00 | 1 day, 13:08:00
VALMET | 234077 | 263:04 |  |  |  |  |  |  |  |  |  | 234077 | 10 days, 23:04:00 | 10 days, 23:04:00
Warranty AirCo Industrial | 994089 | 12:09 |  |  |  |  |  |  |  |  |  | 994089 | 12:09:00 | not found
[NAME] | 244183 | 99:44 |  |  |  |  |  |  |  |  |  | 244183 | 4 days, 3:44:00 | 4 days, 3:01:00
XRG | 234067 | 391:28 | 0:37 |  |  |  |  |  |  |  |  | 234067 | 16 days, 8:05:00 | 16 days, 8:05:00