Finding a group of specific values and Showing First and Last Value

[Kazaard]

Hi Guys,

Im new here and was wondering if someone could help me please.

So the sheet contains the times of booking slots. eg 12:45,13:00,13:15,13:30, these times can be anywhere in the row. So the first time would be the start time of the booking and the last time would be the end of the booking. So if there is 4 time slots essentially they are booking 45min of timeslots between the times. I am looking for a formula or VBA that will give me the first and last times in order to read it into another sheet as a list of bookings.
So the cells EA and EB would say 12:45 and 13:30. If anyone can help I would really appreciate it.

Copy of BCC Book In form.xlsm
	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ
27																							Booking 1		Booking 2		Booking 3		Booking 4		Booking 5
28	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41
29	12:45	13:00	13:15	13:30	13:45	14:00	14:15	14:30	14:45	15:00	15:15	15:30	15:45	16:00	16:15	16:30	16:45	17:00	17:15	17:30	17:45	18:00	Start	End	Start	End	Start	End	Start	End	Start	End
30	12:45:00	13:00:00	13:15:00	13:30:00																	17:45:00	18:00:00
31
32
33
34
35
36										15:00:00	15:15:00	15:30:00	15:45:00
37
38
39
40
41
42
43
44
45
46
47
48
49
Team1

Cell Formulas
Range	Formula
DE30:DZ49	DE30	=IF(OR(AND(DD30="O",Z30="O"),AND(Z30="O"),AND(Y30="O")),DE$29,"")

 

[Fluff]

You're welcome 7 thanks for the feedback.