Selecting the FIRST and LAST time readings from the daily card readings and ignoring the other ones

[Doomglazer]

Im looking for a solution to this problem. In need to see when a certain badge number badges in for the first time and then for the last time. Its also important that the company name is visible.

This is just a snapshot from a period of one day but i need to be able to run it over a months worth of data.

Thanks in advance for the help

testing.xls
	A	B	C	D
1
2		Date and time	Badge nr	Company
3		6/03/2022 0:31	322008125	MPA_Buurtparkeren
4
5		6/03/2022 0:53	322007289
6
7		6/03/2022 0:53	322007289
8
9		6/03/2022 0:53	322007289
10
11		6/03/2022 0:55	322007289
12
13		6/03/2022 1:17	25863	SERIS
14
15		6/03/2022 1:24	25912	MPA_Buurtparkeren
16
17		6/03/2022 1:29	25863	SERIS
18
19		6/03/2022 1:33	25863	SERIS
20
21		6/03/2022 1:33	25863	SERIS
22
23		6/03/2022 1:33	25863	SERIS
24
25		6/03/2022 1:34	25863	SERIS
26
27		6/03/2022 1:36	25863	SERIS
28
29		6/03/2022 1:39	322008129	MPA_Buurtparkeren
30
31		6/03/2022 1:41	25863	SERIS
32
33		6/03/2022 2:05	322004808	MPA_Buurtparkeren
34
35		6/03/2022 2:53	322007284
36
37		6/03/2022 2:53	322007284
38
39		6/03/2022 2:55	322007284
40
41		6/03/2022 2:58	25863	SERIS
42
43		6/03/2022 3:06	25863	SERIS
44
45		6/03/2022 3:59	25863	SERIS
46
47		6/03/2022 4:25	25863	SERIS
48
49		6/03/2022 4:29	25863	SERIS
50
51		6/03/2022 4:31	25863	SERIS
52
53		6/03/2022 4:31	25863	SERIS
54
55		6/03/2022 4:32	25863	SERIS
56
57		6/03/2022 4:33	25863	SERIS
58
59		6/03/2022 4:33	25863	SERIS
60
61		6/03/2022 4:33	25863	SERIS
62
63		6/03/2022 4:34	25863	SERIS
64
65		6/03/2022 4:35	25863	SERIS
66
67		6/03/2022 4:35	25863	SERIS
68
69		6/03/2022 4:36	25863	SERIS
70
71		6/03/2022 4:36	25863	SERIS
72
73		6/03/2022 4:36	25863	SERIS
74
75		6/03/2022 4:37	25863	SERIS
76
77		6/03/2022 4:37	25863	SERIS
78
79		6/03/2022 4:37	25863	SERIS
80
81		6/03/2022 4:39	25863	SERIS
82
83		6/03/2022 4:56	322008121	MPA_Buurtparkeren
84
85		6/03/2022 4:58	322008121	MPA_Buurtparkeren
86
87		6/03/2022 5:36	25863	SERIS
88
89		6/03/2022 6:05	322004804	MPA_Buurtparkeren
90
91		6/03/2022 6:07	322004804	MPA_Buurtparkeren
92
93		6/03/2022 6:15	25863	SERIS
94
95		6/03/2022 6:15	25863	SERIS
96
97		6/03/2022 6:15	25863	SERIS
98
99		6/03/2022 6:15	25863	SERIS
Sheet1

 

[Doomglazer]

What do you use as the separator in formulae?

I change all the , to ; because i work with a ducth version

 

[Fluff]

In that case you need to use {1\2} in the choose function.

 

[Doomglazer]

In that case you need to use {1\2} in the choose function.

Thanx works like a charm and all solved

 

[Fluff]

You're welcome & thanks for the feedback.