# Eclude times outside of business hours?

**URL:** <https://discuss.elastic.co/t/eclude-times-outside-of-business-hours/54306>\
**Category:** Kibana\
**Created:** [June 29, 2016, 3:35pm UTC](https://discuss.elastic.co/t/eclude-times-outside-of-business-hours/54306 "2016-06-29T15:35:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drew\_Town](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drew_town/32/44829_2.png) [@Drew\_Town](https://discuss.elastic.co/u/Drew_Town)\
**Post date:** [June 29, 2016, 3:35pm UTC](https://discuss.elastic.co/t/eclude-times-outside-of-business-hours/54306/1 "2016-06-29T15:35:51Z")

</div>

Is it possible to exclude certain hours or only include certain hours over multiple days?

Say we wanted to only search for events that happened between 9-5 every day but exclude those that happened at 5:30 for this particular query? How would we accomplish this?

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [June 29, 2016, 10:54pm UTC](https://discuss.elastic.co/t/eclude-times-outside-of-business-hours/54306/2 "2016-06-29T22:54:43Z")

</div>

I think you can use the query bar to filter the records by time, so the data won't show up in the visualizations. You'll basically see gaps in the charts for the data outside of that 9-5 range.

If you want that time range in the chart to get skipped though (so that the data is kind of compressed together), that's not possible.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:48pm UTC](https://discuss.elastic.co/t/eclude-times-outside-of-business-hours/54306/3 "2017-07-06T13:48:43Z")

</div>


