Finding rows less than 12 minutes

[sobeitjedi]

Hi.

Here is a sample data export from a car parking system. There are three car parks, Oasis, Winter & Premier, and I would like to know who is parking for less than 12 minutes (the purpose of this is that I only want to charge those people parking longer, not those just dropping off items).

ParkingSheet1

Can you help?

 

[sobeitjedi]

Hi.

Here is a sample data export from a car parking system. There are three car parks, Oasis, Winter & Premier, and I would like to know who is parking for less than 12 minutes (there are rows of data for entering & exiting). The purpose of this is that I only want to charge those people parking longer, not those just dropping off items.

ParkingSheet1

Can you help? Any questions, please ask.

 

[Sufiyan97]

Is it what you want?

Format Column F as "hh:mm:ss"

Parking.csv
	A	B	C	D	E	F	G	H
1	Date and Time	Event	Card number	User name	Component	Time	Charge or Not	0:12
2	15/03/2021 08:43	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:43
3	15/03/2021 17:37	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:37	Charge
4	16/03/2021 08:42	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:42
5	16/03/2021 17:12	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:12	Charge
6	17/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:46
7	17/03/2021 17:22	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:22	Charge
8	19/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:46
9	19/03/2021 17:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:46	Charge
10	22/03/2021 08:45	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:45
11	17/03/2021 08:47	Access granted	75:76755	Bob Edwards	Winter Barrier IN	0:08:47
12	17/03/2021 08:55	Access granted	75:76755	Bob Edwards	Winter Barrier OUT	0:08:55
13	18/03/2021 08:39	Access granted	75:76770	Chris Jameson	Premier St Barrier IN	0:08:39
14	18/03/2021 14:58	Access granted	75:76770	Chris Jameson	Premier St Barrier OUT	0:14:58	Charge
15	22/03/2021 09:16	Access granted	75:76776	Jeff Byrne	Winter Barrier IN	0:09:16
16	18/03/2021 15:16	Access granted	75:76747	Clive Roberts	Premier St Barrier IN	0:15:16	Charge
17	18/03/2021 16:25	Access granted	75:76747	Clive Roberts	Premier St Barrier OUT	0:16:25	Charge
18	17/03/2021 09:17	Access granted	75:76751	Hannah Frank	Oasis Street Barrier IN	0:09:17
19	17/03/2021 12:21	Access granted	75:76751	Hannah Frank	Oasis Street Barrier OUT	0:12:21	Charge
20	17/03/2021 08:41	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:08:41
21	17/03/2021 16:43	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:16:43	Charge
22	18/03/2021 09:08	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:09:08
23	18/03/2021 17:26	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:17:26	Charge
24	19/03/2021 09:01	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:09:01
25	19/03/2021 14:32	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:14:32	Charge
26	22/03/2021 08:59	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:08:59
27	17/03/2021 14:43	Access granted	7C:79405	Sara Burns	Premier St Barrier IN	0:14:43	Charge
28	17/03/2021 15:50	Access granted	7C:79405	Sara Burns	Premier St Barrier OUT	0:15:50	Charge
29	17/03/2021 16:27	Access granted	7C:79454	John Jones	Winter Barrier OUT	0:16:27	Charge
30	22/03/2021 08:42	Access granted	7C:79454	John Jones	Winter Barrier IN	0:08:42
31	16/03/2021 08:48	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:48
32	16/03/2021 16:37	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:37	Charge
33	17/03/2021 08:42	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:42
34	17/03/2021 16:33	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:33	Charge
35	18/03/2021 08:50	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:50
36	18/03/2021 16:30	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:30	Charge
37	19/03/2021 08:37	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:37
38	19/03/2021 16:39	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:39	Charge
39	15/03/2021 08:17	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:17
40	15/03/2021 16:11	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:16:11	Charge
41	16/03/2021 08:05	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:05
42	16/03/2021 11:04	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:11:04
43	16/03/2021 11:20	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:11:20
44	16/03/2021 13:15	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:13:15	Charge
45	17/03/2021 07:58	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:58
46	17/03/2021 14:14	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:14	Charge
47	18/03/2021 07:59	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:59
48	18/03/2021 14:38	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:38	Charge
49	19/03/2021 08:06	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:06
50	19/03/2021 14:50	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:50	Charge
51	22/03/2021 07:57	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:57
52	17/03/2021 14:04	Access granted	7C:79414	Steve Keith	Premier St Barrier IN	0:14:04	Charge
53	17/03/2021 15:53	Access granted	7C:79414	Steve Keith	Premier St Barrier OUT	0:15:53	Charge
54	15/03/2021 08:24	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:08:24
55	15/03/2021 14:49	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:14:49	Charge
56	16/03/2021 09:11	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:11
57	16/03/2021 17:38	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:17:38	Charge
58	18/03/2021 09:17	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:17
59	18/03/2021 17:22	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:17:22	Charge
60	19/03/2021 09:07	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:07
61	19/03/2021 14:45	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:14:45	Charge
62	16/03/2021 09:01	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:09:01
63	16/03/2021 16:37	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:16:37	Charge
64	17/03/2021 08:57	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:08:57
65	17/03/2021 12:21	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:12:21	Charge
66	18/03/2021 08:52	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:08:52
67	18/03/2021 13:48	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:13:48	Charge
68	19/03/2021 09:24	Access granted	7C:79451	Kelly Lennon	Oasis Street Barrier IN	0:09:24
69	19/03/2021 16:50	Access granted	7C:79451	Kelly Lennon	Oasis Street Barrier OUT	0:16:50	Charge
70	19/03/2021 14:17	Access granted	7C:79504	Russell Carlos	Premier St Barrier IN	0:14:17	Charge
71	19/03/2021 15:29	Access granted	7C:79504	Russell Carlos	Premier St Barrier OUT	0:15:29	Charge
72	15/03/2021 08:46	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:46
73	15/03/2021 17:06	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:17:06	Charge
74	17/03/2021 08:49	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:49
75	17/03/2021 12:54	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:12:54	Charge
76	19/03/2021 08:49	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:49
77	19/03/2021 12:54	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:12:54	Charge
78	22/03/2021 08:51	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:51
79	16/03/2021 09:09	Access granted	7C:79519	Julia Marge	Winter Barrier IN	0:09:09
80	16/03/2021 16:15	Access granted	7C:79519	Julia Marge	Winter Barrier OUT	0:16:15	Charge
81	17/03/2021 08:57	Access granted	7C:79519	Julia Marge	Winter Barrier IN	0:08:57
82	17/03/2021 16:21	Access granted	7C:79519	Julia Marge	Winter Barrier OUT	0:16:21	Charge
83	15/03/2021 10:47	Access granted	7C:79544	Lisa Russell	Premier St Barrier IN	0:10:47
84	15/03/2021 14:47	Access granted	7C:79544	Lisa Russell	Premier St Barrier OUT	0:14:47	Charge
85	17/03/2021 08:21	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:21
86	17/03/2021 16:00	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:00	Charge
87	18/03/2021 08:40	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:40
88	18/03/2021 16:45	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:45	Charge
89	19/03/2021 08:23	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:23
90	19/03/2021 16:32	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:32	Charge
91	17/03/2021 11:27	Access granted	7C:79567	William Hand	Oasis Street Barrier IN	0:11:27
92	17/03/2021 12:42	Access granted	7C:79567	William Hand	Oasis Street Barrier OUT	0:12:42	Charge
93	15/03/2021 08:19	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:08:19
94	15/03/2021 16:16	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:16:16	Charge
95	16/03/2021 08:34	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:08:34
96	16/03/2021 16:32	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:16:32	Charge
97	18/03/2021 09:12	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:09:12
98	18/03/2021 15:27	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:15:27	Charge
99	18/03/2021 15:27	Access granted	7C:79967	Kevin Kiln	Winter Barrier IN	0:15:27	Charge
100	18/03/2021 15:30	Access granted	7C:79967	Kevin Kiln	Winter Barrier OUT	0:15:30	Charge
101	19/03/2021 07:36	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:07:36
102	19/03/2021 14:13	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:14:13	Charge
103	15/03/2021 09:47	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:47
104	15/03/2021 14:10	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:10	Charge
105	16/03/2021 09:51	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:51
106	16/03/2021 14:16	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:16	Charge
107	17/03/2021 09:52	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:52
108	17/03/2021 14:21	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:21	Charge
109	18/03/2021 09:45	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:45
110	18/03/2021 14:18	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:18	Charge
111	19/03/2021 09:44	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:44
112	19/03/2021 14:40	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:40	Charge
113	18/03/2021 08:45	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier IN	0:08:45
114	18/03/2021 16:17	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier OUT	0:16:17	Charge
115	22/03/2021 08:30	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier IN	0:08:30
116	17/03/2021 08:56	Access granted	7C:79996	Charles Simpson	Winter Barrier IN	0:08:56
117	17/03/2021 14:53	Access granted	7C:79996	Charles Simpson	Winter Barrier OUT	0:14:53	Charge
118	22/03/2021 09:01	Access granted	14:57677	Sue Downs	Oasis Street Barrier IN	0:09:01
119	15/03/2021 07:44	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:44
120	15/03/2021 14:53	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:53	Charge
121	16/03/2021 07:50	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:50
122	16/03/2021 14:50	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:50	Charge
123	17/03/2021 07:46	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:46
124	17/03/2021 13:43	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:13:43	Charge
125	18/03/2021 07:49	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:49
126	18/03/2021 14:35	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:35	Charge
127	19/03/2021 07:44	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:44
128	19/03/2021 13:02	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:13:02	Charge
129	22/03/2021 07:45	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:45
130	16/03/2021 09:11	Access granted	15:76150	Paul Starr	Premier St Barrier IN	0:09:11
131	16/03/2021 16:40	Access granted	15:76150	Paul Starr	Premier St Barrier OUT	0:16:40	Charge
132	18/03/2021 09:29	Access granted	15:76150	Paul Starr	Premier St Barrier IN	0:09:29
133	18/03/2021 17:05	Access granted	15:76150	Paul Starr	Premier St Barrier OUT	0:17:05	Charge
Parking

 

[sobeitjedi]

Is it what you want?

Format Column F as "hh:mm:ss"

Parking.csv
	A	B	C	D	E	F	G	H
1	Date and Time	Event	Card number	User name	Component	Time	Charge or Not	0:12
2	15/03/2021 08:43	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:43
3	15/03/2021 17:37	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:37	Charge
4	16/03/2021 08:42	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:42
5	16/03/2021 17:12	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:12	Charge
6	17/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:46
7	17/03/2021 17:22	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:22	Charge
8	19/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:46
9	19/03/2021 17:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	0:17:46	Charge
10	22/03/2021 08:45	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN	0:08:45
11	17/03/2021 08:47	Access granted	75:76755	Bob Edwards	Winter Barrier IN	0:08:47
12	17/03/2021 08:55	Access granted	75:76755	Bob Edwards	Winter Barrier OUT	0:08:55
13	18/03/2021 08:39	Access granted	75:76770	Chris Jameson	Premier St Barrier IN	0:08:39
14	18/03/2021 14:58	Access granted	75:76770	Chris Jameson	Premier St Barrier OUT	0:14:58	Charge
15	22/03/2021 09:16	Access granted	75:76776	Jeff Byrne	Winter Barrier IN	0:09:16
16	18/03/2021 15:16	Access granted	75:76747	Clive Roberts	Premier St Barrier IN	0:15:16	Charge
17	18/03/2021 16:25	Access granted	75:76747	Clive Roberts	Premier St Barrier OUT	0:16:25	Charge
18	17/03/2021 09:17	Access granted	75:76751	Hannah Frank	Oasis Street Barrier IN	0:09:17
19	17/03/2021 12:21	Access granted	75:76751	Hannah Frank	Oasis Street Barrier OUT	0:12:21	Charge
20	17/03/2021 08:41	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:08:41
21	17/03/2021 16:43	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:16:43	Charge
22	18/03/2021 09:08	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:09:08
23	18/03/2021 17:26	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:17:26	Charge
24	19/03/2021 09:01	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:09:01
25	19/03/2021 14:32	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	0:14:32	Charge
26	22/03/2021 08:59	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN	0:08:59
27	17/03/2021 14:43	Access granted	7C:79405	Sara Burns	Premier St Barrier IN	0:14:43	Charge
28	17/03/2021 15:50	Access granted	7C:79405	Sara Burns	Premier St Barrier OUT	0:15:50	Charge
29	17/03/2021 16:27	Access granted	7C:79454	John Jones	Winter Barrier OUT	0:16:27	Charge
30	22/03/2021 08:42	Access granted	7C:79454	John Jones	Winter Barrier IN	0:08:42
31	16/03/2021 08:48	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:48
32	16/03/2021 16:37	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:37	Charge
33	17/03/2021 08:42	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:42
34	17/03/2021 16:33	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:33	Charge
35	18/03/2021 08:50	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:50
36	18/03/2021 16:30	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:30	Charge
37	19/03/2021 08:37	Access granted	7C:79456	Simon Clark	Premier St Barrier IN	0:08:37
38	19/03/2021 16:39	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	0:16:39	Charge
39	15/03/2021 08:17	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:17
40	15/03/2021 16:11	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:16:11	Charge
41	16/03/2021 08:05	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:05
42	16/03/2021 11:04	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:11:04
43	16/03/2021 11:20	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:11:20
44	16/03/2021 13:15	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:13:15	Charge
45	17/03/2021 07:58	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:58
46	17/03/2021 14:14	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:14	Charge
47	18/03/2021 07:59	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:59
48	18/03/2021 14:38	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:38	Charge
49	19/03/2021 08:06	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:08:06
50	19/03/2021 14:50	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	0:14:50	Charge
51	22/03/2021 07:57	Access granted	7C:79476	Andrew Time	Premier St Barrier IN	0:07:57
52	17/03/2021 14:04	Access granted	7C:79414	Steve Keith	Premier St Barrier IN	0:14:04	Charge
53	17/03/2021 15:53	Access granted	7C:79414	Steve Keith	Premier St Barrier OUT	0:15:53	Charge
54	15/03/2021 08:24	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:08:24
55	15/03/2021 14:49	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:14:49	Charge
56	16/03/2021 09:11	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:11
57	16/03/2021 17:38	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:17:38	Charge
58	18/03/2021 09:17	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:17
59	18/03/2021 17:22	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:17:22	Charge
60	19/03/2021 09:07	Access granted	7C:79441	Mohamed Ross	Winter Barrier IN	0:09:07
61	19/03/2021 14:45	Access granted	7C:79441	Mohamed Ross	Winter Barrier OUT	0:14:45	Charge
62	16/03/2021 09:01	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:09:01
63	16/03/2021 16:37	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:16:37	Charge
64	17/03/2021 08:57	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:08:57
65	17/03/2021 12:21	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:12:21	Charge
66	18/03/2021 08:52	Access granted	7C:79451	Kelly Lennon	Premier St Barrier IN	0:08:52
67	18/03/2021 13:48	Access granted	7C:79451	Kelly Lennon	Premier St Barrier OUT	0:13:48	Charge
68	19/03/2021 09:24	Access granted	7C:79451	Kelly Lennon	Oasis Street Barrier IN	0:09:24
69	19/03/2021 16:50	Access granted	7C:79451	Kelly Lennon	Oasis Street Barrier OUT	0:16:50	Charge
70	19/03/2021 14:17	Access granted	7C:79504	Russell Carlos	Premier St Barrier IN	0:14:17	Charge
71	19/03/2021 15:29	Access granted	7C:79504	Russell Carlos	Premier St Barrier OUT	0:15:29	Charge
72	15/03/2021 08:46	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:46
73	15/03/2021 17:06	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:17:06	Charge
74	17/03/2021 08:49	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:49
75	17/03/2021 12:54	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:12:54	Charge
76	19/03/2021 08:49	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:49
77	19/03/2021 12:54	Access granted	7C:79516	Angela Gould	Oasis Street Barrier OUT	0:12:54	Charge
78	22/03/2021 08:51	Access granted	7C:79516	Angela Gould	Oasis Street Barrier IN	0:08:51
79	16/03/2021 09:09	Access granted	7C:79519	Julia Marge	Winter Barrier IN	0:09:09
80	16/03/2021 16:15	Access granted	7C:79519	Julia Marge	Winter Barrier OUT	0:16:15	Charge
81	17/03/2021 08:57	Access granted	7C:79519	Julia Marge	Winter Barrier IN	0:08:57
82	17/03/2021 16:21	Access granted	7C:79519	Julia Marge	Winter Barrier OUT	0:16:21	Charge
83	15/03/2021 10:47	Access granted	7C:79544	Lisa Russell	Premier St Barrier IN	0:10:47
84	15/03/2021 14:47	Access granted	7C:79544	Lisa Russell	Premier St Barrier OUT	0:14:47	Charge
85	17/03/2021 08:21	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:21
86	17/03/2021 16:00	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:00	Charge
87	18/03/2021 08:40	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:40
88	18/03/2021 16:45	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:45	Charge
89	19/03/2021 08:23	Access granted	7C:79555	Rachel Holly	Winter Barrier IN	0:08:23
90	19/03/2021 16:32	Access granted	7C:79555	Rachel Holly	Winter Barrier OUT	0:16:32	Charge
91	17/03/2021 11:27	Access granted	7C:79567	William Hand	Oasis Street Barrier IN	0:11:27
92	17/03/2021 12:42	Access granted	7C:79567	William Hand	Oasis Street Barrier OUT	0:12:42	Charge
93	15/03/2021 08:19	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:08:19
94	15/03/2021 16:16	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:16:16	Charge
95	16/03/2021 08:34	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:08:34
96	16/03/2021 16:32	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:16:32	Charge
97	18/03/2021 09:12	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:09:12
98	18/03/2021 15:27	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:15:27	Charge
99	18/03/2021 15:27	Access granted	7C:79967	Kevin Kiln	Winter Barrier IN	0:15:27	Charge
100	18/03/2021 15:30	Access granted	7C:79967	Kevin Kiln	Winter Barrier OUT	0:15:30	Charge
101	19/03/2021 07:36	Access granted	7C:79967	Kevin Kiln	Premier St Barrier IN	0:07:36
102	19/03/2021 14:13	Access granted	7C:79967	Kevin Kiln	Premier St Barrier OUT	0:14:13	Charge
103	15/03/2021 09:47	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:47
104	15/03/2021 14:10	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:10	Charge
105	16/03/2021 09:51	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:51
106	16/03/2021 14:16	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:16	Charge
107	17/03/2021 09:52	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:52
108	17/03/2021 14:21	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:21	Charge
109	18/03/2021 09:45	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:45
110	18/03/2021 14:18	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:18	Charge
111	19/03/2021 09:44	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier IN	0:09:44
112	19/03/2021 14:40	Access granted	7C:79990	Kelly Anders	Oasis Street Barrier OUT	0:14:40	Charge
113	18/03/2021 08:45	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier IN	0:08:45
114	18/03/2021 16:17	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier OUT	0:16:17	Charge
115	22/03/2021 08:30	Access granted	7C:79995	Greg Moyles	Oasis Street Barrier IN	0:08:30
116	17/03/2021 08:56	Access granted	7C:79996	Charles Simpson	Winter Barrier IN	0:08:56
117	17/03/2021 14:53	Access granted	7C:79996	Charles Simpson	Winter Barrier OUT	0:14:53	Charge
118	22/03/2021 09:01	Access granted	14:57677	Sue Downs	Oasis Street Barrier IN	0:09:01
119	15/03/2021 07:44	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:44
120	15/03/2021 14:53	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:53	Charge
121	16/03/2021 07:50	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:50
122	16/03/2021 14:50	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:50	Charge
123	17/03/2021 07:46	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:46
124	17/03/2021 13:43	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:13:43	Charge
125	18/03/2021 07:49	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:49
126	18/03/2021 14:35	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:14:35	Charge
127	19/03/2021 07:44	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:44
128	19/03/2021 13:02	Access granted	14:57661	Henry Thomas	Oasis Street Barrier OUT	0:13:02	Charge
129	22/03/2021 07:45	Access granted	14:57661	Henry Thomas	Oasis Street Barrier IN	0:07:45
130	16/03/2021 09:11	Access granted	15:76150	Paul Starr	Premier St Barrier IN	0:09:11
131	16/03/2021 16:40	Access granted	15:76150	Paul Starr	Premier St Barrier OUT	0:16:40	Charge
132	18/03/2021 09:29	Access granted	15:76150	Paul Starr	Premier St Barrier IN	0:09:29
133	18/03/2021 17:05	Access granted	15:76150	Paul Starr	Premier St Barrier OUT	0:17:05	Charge
Parking

Many thanks for the reply but I'm not sure the logic is right? The date/time in column A is the date and time the person entered/exited the car park, but I think you've used this as the time spent (ie, F3 = 17:37 as in the time of day (5:37pm), but your calculation is 17:37 is greater than 12 minutes so charge?? Am I reading it right?

 

[Fluff]

Maybe

Parking.csv
	A	B	C	D	E	F
1	Date and Time	Event	Card number	User name	Component
2	15/03/2021 08:43	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
3	15/03/2021 17:37	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
4	16/03/2021 08:42	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
5	16/03/2021 17:12	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
6	17/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
7	17/03/2021 17:22	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
8	19/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
9	19/03/2021 17:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
10	22/03/2021 08:45	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
11	17/03/2021 08:47	Access granted	75:76755	Bob Edwards	Winter Barrier IN
12	17/03/2021 08:55	Access granted	75:76755	Bob Edwards	Winter Barrier OUT
13	18/03/2021 08:39	Access granted	75:76770	Chris Jameson	Premier St Barrier IN
14	18/03/2021 14:58	Access granted	75:76770	Chris Jameson	Premier St Barrier OUT	Charge
15	22/03/2021 09:16	Access granted	75:76776	Jeff Byrne	Winter Barrier IN
16	18/03/2021 15:16	Access granted	75:76747	Clive Roberts	Premier St Barrier IN
17	18/03/2021 16:25	Access granted	75:76747	Clive Roberts	Premier St Barrier OUT	Charge
18	17/03/2021 09:17	Access granted	75:76751	Hannah Frank	Oasis Street Barrier IN
19	17/03/2021 12:21	Access granted	75:76751	Hannah Frank	Oasis Street Barrier OUT	Charge
20	17/03/2021 08:41	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
21	17/03/2021 16:43	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
22	18/03/2021 09:08	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
23	18/03/2021 17:26	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
24	19/03/2021 09:01	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
25	19/03/2021 14:32	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
26	22/03/2021 08:59	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
27	17/03/2021 14:43	Access granted	7C:79405	Sara Burns	Premier St Barrier IN
28	17/03/2021 15:50	Access granted	7C:79405	Sara Burns	Premier St Barrier OUT	Charge
29	17/03/2021 16:27	Access granted	7C:79454	John Jones	Winter Barrier OUT
30	22/03/2021 08:42	Access granted	7C:79454	John Jones	Winter Barrier IN
31	16/03/2021 08:48	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
32	16/03/2021 16:37	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
33	17/03/2021 08:42	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
34	17/03/2021 16:33	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
35	18/03/2021 08:50	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
36	18/03/2021 16:30	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
37	19/03/2021 08:37	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
38	19/03/2021 16:39	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
39	15/03/2021 08:17	Access granted	7C:79476	Andrew Time	Premier St Barrier IN
40	15/03/2021 16:11	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	Charge
Parking

Cell Formulas
Range	Formula
F2:F40	F2	=IF(AND(RIGHT(E2,3)="out",C2=C1),IF((A2-A1)*1440>12,"Charge",""),"")

 

[sobeitjedi]

Maybe

Parking.csv
	A	B	C	D	E	F
1	Date and Time	Event	Card number	User name	Component
2	15/03/2021 08:43	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
3	15/03/2021 17:37	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
4	16/03/2021 08:42	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
5	16/03/2021 17:12	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
6	17/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
7	17/03/2021 17:22	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
8	19/03/2021 08:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
9	19/03/2021 17:46	Access granted	75:76704	Sue Jones	Oasis Street Barrier OUT	Charge
10	22/03/2021 08:45	Access granted	75:76704	Sue Jones	Oasis Street Barrier IN
11	17/03/2021 08:47	Access granted	75:76755	Bob Edwards	Winter Barrier IN
12	17/03/2021 08:55	Access granted	75:76755	Bob Edwards	Winter Barrier OUT
13	18/03/2021 08:39	Access granted	75:76770	Chris Jameson	Premier St Barrier IN
14	18/03/2021 14:58	Access granted	75:76770	Chris Jameson	Premier St Barrier OUT	Charge
15	22/03/2021 09:16	Access granted	75:76776	Jeff Byrne	Winter Barrier IN
16	18/03/2021 15:16	Access granted	75:76747	Clive Roberts	Premier St Barrier IN
17	18/03/2021 16:25	Access granted	75:76747	Clive Roberts	Premier St Barrier OUT	Charge
18	17/03/2021 09:17	Access granted	75:76751	Hannah Frank	Oasis Street Barrier IN
19	17/03/2021 12:21	Access granted	75:76751	Hannah Frank	Oasis Street Barrier OUT	Charge
20	17/03/2021 08:41	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
21	17/03/2021 16:43	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
22	18/03/2021 09:08	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
23	18/03/2021 17:26	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
24	19/03/2021 09:01	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
25	19/03/2021 14:32	Access granted	75:76765	Homer Williams	Oasis Street Barrier OUT	Charge
26	22/03/2021 08:59	Access granted	75:76765	Homer Williams	Oasis Street Barrier IN
27	17/03/2021 14:43	Access granted	7C:79405	Sara Burns	Premier St Barrier IN
28	17/03/2021 15:50	Access granted	7C:79405	Sara Burns	Premier St Barrier OUT	Charge
29	17/03/2021 16:27	Access granted	7C:79454	John Jones	Winter Barrier OUT
30	22/03/2021 08:42	Access granted	7C:79454	John Jones	Winter Barrier IN
31	16/03/2021 08:48	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
32	16/03/2021 16:37	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
33	17/03/2021 08:42	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
34	17/03/2021 16:33	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
35	18/03/2021 08:50	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
36	18/03/2021 16:30	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
37	19/03/2021 08:37	Access granted	7C:79456	Simon Clark	Premier St Barrier IN
38	19/03/2021 16:39	Access granted	7C:79456	Simon Clark	Premier St Barrier OUT	Charge
39	15/03/2021 08:17	Access granted	7C:79476	Andrew Time	Premier St Barrier IN
40	15/03/2021 16:11	Access granted	7C:79476	Andrew Time	Premier St Barrier OUT	Charge
Parking

Cell Formulas
Range	Formula
F2:F40	F2	=IF(AND(RIGHT(E2,3)="out",C2=C1),IF((A2-A1)*1440>12,"Charge",""),"")

Looks great, but if possible, I need to add one further requirement - a person can only be charged once per date. So in instances where there are two durations over 12 minutes on the same date, charge for the longest duration only.

Hopefully that makes sense.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[sobeitjedi]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Using versions of Excel downloaded from my 365 profile. I have two devices and the versions running are:
1) Version 2002 (Build 11929.20606 click to run)
2) Version 2102 (Build 13801.20294 click to run)

Does that help?

 

[Sufiyan97]

Many thanks for the reply but I'm not sure the logic is right? The date/time in column A is the date and time the person entered/exited the car park, but I think you've used this as the time spent (ie, F3 = 17:37 as in the time of day (5:37pm), but your calculation is 17:37 is greater than 12 minutes so charge?? Am I reading it right?

You are correct. I did not understand your question and data well.

 

[sobeitjedi]

You are correct. I did not understand your question and data well.

I still appreciate you taking time to reply and help - thank you!