I have 2 Column sheet with different formatting. I need to calculate the time difference. Thanks
Time Diference.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Ticket Opened Date | Resolved Date Time | ||
2 | 30/06/2020 06:25 PM | 2/7/2020 16:55 | ||
3 | 30/06/2020 04:40 PM | 30/06/2020 06:16 PM | ||
4 | 30/06/2020 12:20 PM | 30/06/2020 04:32 PM | ||
5 | 30/06/2020 11:52 AM | 30/06/2020 06:39 PM | ||
6 | 30/06/2020 11:57 AM | 30/06/2020 11:57 AM | ||
7 | 30/06/2020 11:28 AM | 30/06/2020 05:50 PM | ||
8 | 30/06/2020 10:51 AM | 30/06/2020 11:54 AM | ||
9 | 30/06/2020 10:34 AM | 30/06/2020 10:35 AM | ||
10 | 30/06/2020 10:11 AM | 30/06/2020 08:55 PM | ||
11 | 29/06/2020 01:34 PM | 30/06/2020 03:54 PM | ||
12 | 29/06/2020 01:27 PM | 29/06/2020 06:02 PM | ||
13 | 29/06/2020 01:22 PM | 30/06/2020 02:50 PM | ||
14 | 29/06/2020 12:34 PM | 29/06/2020 06:06 PM | ||
15 | 29/06/2020 11:35 AM | 29/06/2020 11:35 AM | ||
16 | 29/06/2020 12:16 AM | 29/06/2020 03:43 PM | ||
17 | 28/06/2020 03:10 AM | 5/7/2020 15:16 | ||
18 | 27/06/2020 03:23 PM | 30/06/2020 10:35 PM | ||
19 | 26/06/2020 12:21 PM | 29/06/2020 03:18 PM | ||
20 | 26/06/2020 12:04 PM | 27/06/2020 05:02 PM | ||
21 | 26/06/2020 12:02 PM | 29/06/2020 01:43 PM | ||
22 | 26/06/2020 11:26 AM | 30/06/2020 11:49 AM | ||
23 | 25/06/2020 04:52 PM | 26/06/2020 12:15 PM | ||
24 | 25/06/2020 03:40 PM | 1/7/2020 14:55 | ||
25 | 24/06/2020 12:54 PM | 24/06/2020 04:53 PM | ||
26 | 24/06/2020 12:04 PM | 25/06/2020 02:46 PM | ||
27 | 24/06/2020 11:31 AM | 24/06/2020 11:32 AM | ||
28 | 24/06/2020 11:00 AM | 24/06/2020 11:26 AM | ||
29 | 24/06/2020 10:10 AM | 24/06/2020 04:51 PM | ||
30 | 23/06/2020 04:04 PM | 24/06/2020 02:41 PM | ||
31 | 23/06/2020 03:17 PM | 23/06/2020 03:18 PM | ||
32 | 23/06/2020 12:20 PM | 23/06/2020 06:38 PM | ||
33 | 23/06/2020 11:44 AM | 25/06/2020 02:48 PM | ||
34 | 23/06/2020 11:21 AM | 2/7/2020 13:52 | ||
35 | 23/06/2020 09:39 AM | 23/06/2020 06:35 PM | ||
36 | 22/06/2020 11:17 AM | 22/06/2020 03:47 PM | ||
37 | 22/06/2020 10:48 AM | 22/06/2020 11:07 AM | ||
38 | 19/06/2020 12:55 PM | 20/06/2020 03:24 PM | ||
39 | 19/06/2020 12:06 PM | 23/06/2020 05:44 PM | ||
40 | 19/06/2020 11:36 AM | 19/06/2020 11:37 AM | ||
41 | 19/06/2020 10:58 AM | 19/06/2020 03:30 PM | ||
42 | 19/06/2020 07:23 AM | 19/06/2020 07:24 AM | ||
43 | 18/06/2020 01:09 PM | 18/06/2020 02:16 PM | ||
44 | 18/06/2020 11:05 AM | 18/06/2020 11:07 AM | ||
45 | 17/06/2020 04:21 PM | 18/06/2020 04:37 PM | ||
46 | 17/06/2020 12:00 PM | 17/06/2020 12:01 PM | ||
47 | 16/06/2020 05:13 PM | 17/06/2020 11:23 AM | ||
48 | 15/06/2020 09:32 PM | 16/06/2020 10:01 AM | ||
49 | 15/06/2020 12:29 PM | 15/06/2020 12:58 PM | ||
50 | 12/6/2020 20:27 | 15/06/2020 10:17 AM | ||
51 | 12/6/2020 12:37 | 15/06/2020 10:18 AM | ||
52 | 11/6/2020 17:02 | 15/06/2020 11:33 AM | ||
53 | 11/6/2020 15:46 | 17/06/2020 06:01 PM | ||
54 | 11/6/2020 14:44 | 12/6/2020 12:44 | ||
55 | 11/6/2020 14:01 | 16/06/2020 12:24 PM | ||
56 | 11/6/2020 11:42 | 15/06/2020 03:24 PM | ||
57 | 10/6/2020 18:30 | 10/6/2020 23:12 | ||
58 | 10/6/2020 15:08 | |||
59 | 10/6/2020 14:52 | 11/6/2020 10:22 | ||
60 | 10/6/2020 14:17 | 10/6/2020 14:57 | ||
61 | 9/6/2020 18:01 | 11/6/2020 10:12 | ||
62 | 9/6/2020 17:24 | 9/6/2020 17:39 | ||
63 | 9/6/2020 0:31 | 9/6/2020 9:57 | ||
64 | 8/6/2020 15:55 | 8/6/2020 15:56 | ||
65 | 8/6/2020 10:25 | 9/6/2020 15:52 | ||
66 | 5/6/2020 14:00 | 6/6/2020 12:19 | ||
67 | 5/6/2020 10:02 | 6/6/2020 12:23 | ||
68 | 4/6/2020 16:25 | |||
69 | 4/6/2020 12:40 | 4/6/2020 12:41 | ||
70 | 4/6/2020 12:11 | 4/6/2020 13:52 | ||
71 | 4/6/2020 10:29 | 4/6/2020 10:31 | ||
72 | 4/6/2020 10:23 | 4/6/2020 12:24 | ||
73 | 4/6/2020 9:56 | 4/6/2020 9:56 | ||
74 | 3/6/2020 10:05 | 3/6/2020 11:11 | ||
75 | 2/6/2020 20:16 | 3/6/2020 11:13 | ||
76 | 2/6/2020 11:00 | 4/6/2020 15:36 | ||
77 | 2/6/2020 10:40 | 2/6/2020 12:57 | ||
78 | 1/6/2020 23:38 | 2/6/2020 11:08 | ||
79 | 1/6/2020 21:59 | 2/6/2020 16:39 | ||
80 | 1/6/2020 19:51 | 2/6/2020 14:24 | ||
81 | 1/6/2020 19:54 | |||
82 | 1/6/2020 11:44 | |||
Difference |