# Hour Database Adalo

**URL:** <https://forum.adalo.com/t/hour-database-adalo/3059>\
**Category:** Get Help\
**Created:** [August 6, 2020, 3:22pm UTC](https://forum.adalo.com/t/hour-database-adalo/3059 "2020-08-06T15:22:00Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [August 6, 2020, 5:05pm UTC](https://forum.adalo.com/t/hour-database-adalo/3059/4 "2020-08-06T17:05:24Z")

</div>

@CNST I would not go for a big prepared calendar you have to maintain regularly.

1. Each company should have a pattern of working hours/shifts based on weekdays.  
For work with weekdays see: [How to derive weekdays from a date - #2 by Ben](https://forum.adalo.com/t/how-to-derive-weekdays-from-a-date/2374/2)
2. Each company has a holiday calendar (public holidays etc.).
3. During the operating hours (standard working days and opening hours except holidays) a company has one or many shifts. (=\> Closed during lunch break)
4. Each shift has one or many employees assigned.
5. A shift can have multiple slots/session to be booked.
6. A customer can book a session in a certain time slot with an available employee.

---

_[View the full topic](https://forum.adalo.com/t/hour-database-adalo/3059)._