# Create Weekday Start Time / End Time Conditions with ZERO spreadsheet formulas **URL:** \ **Category:** Community Resources\ **Created:** [December 10, 2020, 3:31pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662 "2020-12-10T15:31:10Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 10, 2020, 3:31pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/1 "2020-12-10T15:31:10Z")
Last week, Glide released more mathematical functions in the math column (see [šŸ“… MORE Date Math incl. Weeknum!](https://community.glideapps.com/t/more-date-math-incl-weeknum/19386)). Leveraging these new functions, you can now create Weekday start/end time conditions (restaurants, stores, class periods, etc.) with ZERO spreadsheet formulas. Take a look! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 10, 2020, 4:48pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/2 "2020-12-10T16:48:17Z")
@Robert_Petitto thatā€™s a winner right there. Zero google formulas @ instant results šŸ‘ This certainly is a very powerful function which addresses many use cases. As always thanks for putting together and sharing, Book marked this oneā€¦(adding to my ever growing library) ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [December 10, 2020, 5:26pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/3 "2020-12-10T17:26:57Z")
This is great @Robert_Petitto! Exactly what I needed! Thanks again for your tutorials! I have a question in regards to the setup: First, some context: we have an app that hosts multiple businesses and pages that include their hours of operation. I literally updated each individual set of hours Sun-Sat for 237 businesses - I know, shoot me! šŸ¤Ŗ I didnā€™t even think to do this - but would it be possible to use this setup, but for multiple listings? Aka - allow said businesses to be able to input/edit their own hours of operation from a single sheet or table? I assume I would have to create Admin access pages/toggles, user specific profiles/columns, and then throw in the kitchen sinkā€¦šŸ˜ Thanks for any and all help! šŸ™šŸ» ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 10, 2020, 5:49pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/4 "2020-12-10T17:49:57Z")
Yes. User specific columns would be the EASIEST by farā€¦but it would only work if users were ONLY looking at their own business. If you needed to have the user view the hours of MULTIPLE businesses, then youā€™d need a form to track the hours for each business. ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [December 10, 2020, 5:55pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/5 "2020-12-10T17:55:24Z")
Very good contribution @Robert_Petitto ! I think it will serve me for multiple businesses. I would add special dates that stores can open. I understand that it can be done. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [December 10, 2020, 5:57pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/6 "2020-12-10T17:57:16Z")
Ok great! yeah they would only be looking at their own business! So on their details page, I would just create a form (that only allowed users could see, conditions) that says ā€œEdit Hoursā€ and it could then pull up just that data from their column(s), etcā€¦? I guess I could just create a toggle switch that would trigger an ā€œOpen/Closedā€ image or button on their details page as wellā€¦Iā€™m just a sucker for good UX šŸ¤“ so I wanted it to look good! Thanks again! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [December 10, 2020, 5:59pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/7 "2020-12-10T17:59:48Z")
Excellent, as always! ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [December 10, 2020, 7:44pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/8 "2020-12-10T19:44:52Z")
And we have a winner. Thank you so much for your help. nighty night yā€™all šŸ„± ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 2:16am UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/9 "2020-12-11T02:16:27Z")
> [@Rosewebstudio](#): > > As always thanks for putting together and sharing, > > Book marked this oneā€¦(adding to my ever growing library) Probably easier just to bookmark Robā€™s [user page](https://community.glideapps.com/u/robert_petitto) šŸ˜‚ ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 11, 2020, 5:38am UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/10 "2020-12-11T05:38:39Z")
@Darren_Murphy gosh I donā€™t have that much time šŸ˜‰ ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 11, 2020, 10:23am UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/11 "2020-12-11T10:23:15Z")
Yā€™all are too much šŸ„° ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [December 11, 2020, 7:24pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/12 "2020-12-11T19:24:56Z")
Hey @Robert_Petitto, wouldnā€™t this logic help with booking slots when you have different durations? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 11, 2020, 9:17pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/13 "2020-12-11T21:17:18Z")
Hmā€¦possiblyā€¦can you elaborate on your thoughts? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [December 11, 2020, 9:19pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/14 "2020-12-11T21:19:54Z")
I am thinking your Meet Me logic. I was wondering if that Start Time/End Time conditions could be use to achieve what you did with that app. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 11, 2020, 9:21pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/15 "2020-12-11T21:21:29Z")
Potentially. I did something similar with a different room booking appā€¦The difference is that the meet with me doesnā€™t use a true time column because itā€™s fabricated using the choice component. However the logic is still sound because I could compare the fabricated value with a fabricated Now value. Itā€™s worth looking into. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [December 11, 2020, 9:22pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/16 "2020-12-11T21:22:25Z")
Cool! Iā€™ll tinker with it and see. Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 12, 2020, 12:33am UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/17 "2020-12-12T00:33:33Z")
Great video again Bob! One question from me, in the If columns at the end, can we combine: If Now is before StartTime then 0 If Now is after EndTime then 0 Else 1 Would it work and save 1 column? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 12, 2020, 2:07am UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/18 "2020-12-12T02:07:54Z")
It would! Someone else suggested that to me as well in a comment to my YouTube videoā€¦much more efficient. Thatā€™s what I love about Clyde. More than one way to approach a solution! ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [December 16, 2020, 10:39pm UTC](https://community.glideapps.com/t/create-weekday-start-time-end-time-conditions-with-zero-spreadsheet-formulas/19662/19 "2020-12-16T22:39:54Z")
neat. will be curious to see how this performs relative to: if StartTime is before now - true if EndTime is on or after now - true template column combining both if true-true = Open, else closed