How to get unique date and time between two dates?

[worldCurrencies]

I haven't found an answer that includes time.

Threshold Dates	Date	Time	Result
1/9/2023	1/9/2023	8:00:00	{=SORT(UNIQUE(FILTER(CONCATENATE(TEXT($B$2:$B$6,"m/d/yyyy")," ",$C$2:$C$6),(List!$B$2:$B$6>=$A$2)*($B$2:$B$6<=$A$3),"no result"),FALSE,TRUE))}
1/13/2023	1/8/2023	10:00:00
	1/10/2023	8:30:00
	1/10/2023	10:00:00
	1/13/2023	2:30:00

The array formula i have in column D half-way does the trick. It gives me unique dates within that time frame, however, i am looking to include time as well. It gives me the output below:

1/9/2023 8:00:00

1/10/2023 8:30:00

1/13/2023 2:30:00

I am trying to include the second 1/10 date into the answer as well

 

[Alex Blakenburg]

I am not sure I am understanding correctly but try the below.
See if this is what you had in mind.

=LET(date_time,  B2:B6+C2:C6,
         fltr_result,   FILTER(date_time, (date_time>=A2) * (date_time<(A3+1)), "no result"),
         SORT(UNIQUE(  fltr_result  )))

 

[Peter_SSs]

I think this should produce the same result. My dates are d/m/y format.

23 01 14.xlsm
	A	B	C	D
1	Threshold Dates	Date	Time	Result
2	9/01/2023	9/01/2023	8:00:00	9/1/2023 8:00:00
3	13/01/2023	8/01/2023	10:00:00	10/1/2023 8:30:00
4		10/01/2023	8:30:00	10/1/2023 10:00:00
5		10/01/2023	10:00:00	13/1/2023 2:30:00
6		13/01/2023	2:30:00
Date Time

Cell Formulas
Range	Formula
D2:D5	D2	=SORT(UNIQUE(FILTER(B2:B6+C2:C6,(B2:B6>=A2)*(B2:B6<=A3),"")))
Dynamic array formulas.

.. or would you want that last row excluded from the results?
If so would it be possible for any of your times to be 0:00:00?

 

[worldCurrencies]

I think this should produce the same result. My dates are d/m/y format.

23 01 14.xlsm
	A	B	C	D
1	Threshold Dates	Date	Time	Result
2	9/01/2023	9/01/2023	8:00:00	9/1/2023 8:00:00
3	13/01/2023	8/01/2023	10:00:00	10/1/2023 8:30:00
4		10/01/2023	8:30:00	10/1/2023 10:00:00
5		10/01/2023	10:00:00	13/1/2023 2:30:00
6		13/01/2023	2:30:00
Date Time

Cell Formulas
Range	Formula
D2:D5	D2	=SORT(UNIQUE(FILTER(B2:B6+C2:C6,(B2:B6>=A2)*(B2:B6<=A3),"")))
Dynamic array formulas.

.. or would you want that last row excluded from the results?
If so would it be possible for any of your times to be 0:00:00?

No, this is perfect. Everybody’s answers worked. I appreciate it!!

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.

(Of course if your dates and times are chronological like you sample, then you wouldn't need the SORT function)