How to create a slicer the start/end TIME?

[Anonymous]

Hello, colleagues!
Hope you are well.

I'm struggling to create a slicer for time on Power BI.
I have a table with the Start Time and the End Time for each item.
I would like to create a slicer/filter where people could indicate the start time and the end time and power BI will filter the items on the table.

My table:

id | starttime | endtime 
3  | 4:30 AM   | 6:46 AM 
1  | 12:01 AM | 3:37 AM 
4  | 12:10 PM | 12:52 PM 
5  | 12:10 PM | 12:41 PM 
6  | 12:10 PM | 12:49 PM 
7  | 12:10 PM | 1:00 PM 

Example if I select 12:00 PM as start time and 01:00PM as end time it should show me the items 4,5,6 and 7.
I've tried using the slicer, however looks like the option "between" only works with Dates.

Can someone help me?

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiFbifN58ZozX2sVB?e=5wVS3B

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Start time and End time are split into 2 columns, so if you need to filter data based on the slot between the start date and end date you need 2 slicers one for each column:

The slicers should be drop-down lists.

Link to a sample file 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiFbifN58ZozX2sVB?e=5wVS3B