# Creating half an hour time slots from Opening to Closing of a business

**URL:** <https://forum.adalo.com/t/creating-half-an-hour-time-slots-from-opening-to-closing-of-a-business/4842>\
**Category:** Get Help\
**Created:** [October 13, 2020, 6:41am UTC](https://forum.adalo.com/t/creating-half-an-hour-time-slots-from-opening-to-closing-of-a-business/4842 "2020-10-13T06:41:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![draspavkiev](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/draspavkiev/32/2031_2.png) [@draspavkiev](https://forum.adalo.com/u/draspavkiev)\
**Post date:** [October 13, 2020, 6:41am UTC](https://forum.adalo.com/t/creating-half-an-hour-time-slots-from-opening-to-closing-of-a-business/4842/1 "2020-10-13T06:41:28Z")

</div>

Hi,

I have an appointment booking application that inputs the opening and closing times of an establishment,  
Based on these two time slots, I need to show different timeslots with half an hour increments.  
Eg: Start Time - 9:00 AM and End Time:6:00PM, I will need time slots like this: 9:00AM, 9:30 AM, 10:00:AM…  
Added complexity is that there needs to be another filter which needs to compare these time slots with a time field from another collection called Appointments and filter out the time slots already present in that collection.

I am able to do the first part where it only shows time slots between 9 and 6 PM. I have created a Master time slot collection with timeslots from 6 AM to 8PM and I just show time slots between the timings entered by the establishment. But I am unable to filter out these remaining time slots by comparing it to the appointment collection.  
Can someone please guide me on this?

---

<div class="post-metadata">

**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\
**Post date:** [October 19, 2020, 11:21am UTC](https://forum.adalo.com/t/creating-half-an-hour-time-slots-from-opening-to-closing-of-a-business/4842/2 "2020-10-19T11:21:54Z")

</div>

Hi @draspavkiev, sorry for replying so late here.

This indeed does require a more complicated setup. My advice here would be to consult with an

[Adalo Expert](https://www.adalo.com/experts)

who would be able to either set this up for you, or coach you further on how you could complete this effectively.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [October 29, 2020, 11:21am UTC](https://forum.adalo.com/t/creating-half-an-hour-time-slots-from-opening-to-closing-of-a-business/4842/3 "2020-10-29T11:21:54Z")

</div>

Closed on October 29, 2020, 11:21am UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.