Spreadsheet: 797064d1663691841-calculate-response-time-between-2-dates-and-time-within-business-hours-example
Sheet: Ark1

Plant | Order | Description | Type | Work Center | Required Start Date | Required Start Time | Actual Start Date | Actual Start Time
MFD | 35386414 | 1/8 [NAME] 1415 KAN IKKE LAVE KAKAO, SKRIV | Call out | ENI | 2022-08-01 00:00:00 | 14:17:04 | 2022-08-02 00:00:00 | [NAME]
MFD | 35386847 | 3/8 KL 13,15 DEN SIGER DER IKKE ER BNNE | Call out | SHA | 2022-08-03 00:00:00 | 14:11:38 | 2022-08-04 00:00:00 | 11:11:36
MFD | 35387239 | 8/8 KL 8,00 KOPHOLDER KNKKET | Call out | HMO | 2022-08-08 00:00:00 | 08:41:53 | 2022-08-09 00:00:00 | 08:44:16
MFD | 35388121 | 11/8 1356-VANDFLOW | Call out | NAND | 2022-08-11 00:00:00 | 13:58:10 | 2022-08-12 00:00:00 | 06:54:11
MFD | 35388123 | 11/8 KL 1404 FEJL BEHOLDER 3 | Call out | NAND | 2022-08-11 00:00:00 | 14:06:20 | 2022-08-12 00:00:00 | 09:26:47
MFD | 35388256 | 11/8 KL 1548 - PROBLEMER MED KVRN | Call out | SHA | 2022-08-12 00:00:00 | 11:32:48 | 2022-08-12 00:00:00 | 13:07:18
MFD | 35388279 | 12/8 KL 1245 - VIRKER IKKE, FILTERSKIF | Call out | NAND | 2022-08-12 00:00:00 | [NAME] | 2022-08-15 00:00:00 | 11:16:35
MFD | 35388280 | 12/8 KL 1247 - FEJL UNDER LUKNING | Call out | NAND | 2022-08-12 00:00:00 | 12:47:54 | 2022-08-15 00:00:00 | 11:30:40
MFD | 35388281 | 12/8 KL 1247 - FEJL UNDER LUKNING | Call out | NAND | 2022-08-12 00:00:00 | 12:48:34 | 2022-08-15 00:00:00 | 11:41:10
MFD | 35388282 | 12/8 KL 1248 BEHOLDER NDVENDIG EMK | Call out | NAND | 2022-08-12 00:00:00 | 12:49:45 | 2022-08-15 00:00:00 | 11:53:22
MFD | 35388284 | 12/8 KL 1250 - SKRIVER DEN MANGLER BN | Call out | NAND | 2022-08-12 00:00:00 | 12:51:08 | 2022-08-15 00:00:00 | 08:59:00
MFD | 35388342 | 15/8 814 FEJL LUKNING SIHOVED | Call out | NAND | 2022-08-15 00:00:00 | 08:16:47 | 2022-08-16 00:00:00 | 09:09:13
MFD | 35388815 | 1708 0818 SPILDBAKKE FULD | Call out | PBH | 2022-08-17 00:00:00 | 08:20:42 | 2022-08-17 00:00:00 | 10:16:08
MFD | 35388819 | 1708 0820 SPILBAKKE FULD | Call out | PBH | 2022-08-17 00:00:00 | 08:24:26 | 2022-08-17 00:00:00 | 10:12:52
MFD | 35388829 | 17/8 836 MELDER WASTEBUCKET FULL MENTOM | Call out | PBH | 2022-08-17 00:00:00 | 08:37:22 | 2022-08-17 00:00:00 | [NAME]
MFD | 35388833 | KONTAKT: 41762043 | Call out | PBH | 2022-08-17 00:00:00 | 08:40:38 | 2022-08-17 00:00:00 | 10:05:28
MFD | 35388936 | 17/8 KL 1254 - NIVEAU FEJL | Call out | MBO | 2022-08-17 00:00:00 | 12:55:27 | 2022-08-18 00:00:00 | 08:12:09
MFD | 35389333 | 19/8 9,00 NSKER KALD AF TEKNIKER AHMAD | Call out | PBH | 2022-08-19 00:00:00 | 09:03:29 | 2022-08-19 00:00:00 | 11:02:06
MFD | 35389563 | 22/8 KL 0951 KAN IKKE LAVE KAKAO | Call out | HMO | 2022-08-22 00:00:00 | 09:52:18 | 2022-08-22 00:00:00 | [NAME]
MFD | 35389770 | 22/8-2022 15:13 KONTAKTPERSON: NTTP | Call out | SHA | 2022-08-22 00:00:00 | 16:05:46 | 2022-08-23 00:00:00 | 12:22:46
MFD | 35389815 | 23/8 830 AIRBRAKE | Call out | MAH | 2022-08-23 00:00:00 | 08:35:21 | 2022-08-24 00:00:00 | 07:28:10
MFD | 35389816 | 23/8 830 KAFFE UD SOM VAND | Call out | MAH | 2022-08-23 00:00:00 | 08:36:57 | 2022-08-24 00:00:00 | 09:10:07
MFD | 35390797 | 29/8 1030 AIR BRAKE [NAME], [NAME] VANDFLOW | Call out | RSV | 2022-08-29 00:00:00 | 10:32:06 | 2022-08-29 00:00:00 | 12:41:14
MFD | 35391274 | 31/8 KL 0859 VIRKER IKKE | Call out | MFD-OUT | 2022-08-31 00:00:00 | 09:00:59
MFD | 35391337 | LOVET I DAG BOSSEN 31081040 AIR BREA | Call out | MAH | 2022-08-31 00:00:00 | 10:42:22 | 2022-08-31 00:00:00 | 11:55:29
MFD | 35391371 | 31/8 11,56 DER KOMMER INTET VAND UD | Call out | RSV | 2022-08-31 00:00:00 | 11:17:41 | 2022-09-01 00:00:00 | 09:37:23