# If-Then-Else for TIME **URL:** \ **Category:** Ask for Help\ **Created:** [April 12, 2025, 9:24pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308 "2025-04-12T21:24:53Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![FabriMC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrimc/32/85864_2.png) [@FabriMC](https://community.glideapps.com/u/FabriMC)\ **Post date:** [April 12, 2025, 9:24pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/1 "2025-04-12T21:24:53Z")
Hi, I am trying to create a daily log for my staff. That it is only active as long as the current time is between “Time Start” and “Time End”, but I don’t know what I am doing wrong. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff772722e73b1cf200283b0a4672a2fa4a08fb4b.png) This is my column if ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ceabbe90a67c8a0dff6116465e36e11e1ad134a1.png) ---
**Author:** ![Chloe\_Mason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_mason/32/87120_2.png) [@Chloe\_Mason](https://community.glideapps.com/u/Chloe_Mason)\ **Post date:** [April 12, 2025, 9:37pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/2 "2025-04-12T21:37:47Z")
I am by means an expert in glide but I do have a tip that I believe will work. If you create a template column that is set to the value of “Current Time” then you can change your if/then/else column to where “if” is pulling from the “Current Time” column. You can make it [if “Current Time” is after “Time Start”] and [if “Current Time” is before “Time Start”]. Let me know if this works for you or if you have any other questions! ---
**Author:** ![Chloe\_Mason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_mason/32/87120_2.png) [@Chloe\_Mason](https://community.glideapps.com/u/Chloe_Mason)\ **Post date:** [April 12, 2025, 9:41pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/3 "2025-04-12T21:41:28Z")
It also looks like you have the “Time Start” and “Time End” columns set to a certain date. This will cause you problems. If you want it to allow for the same time slots each day, I would use a time only column instead of the date and time. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 12, 2025, 9:42pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/4 "2025-04-12T21:42:30Z")
Use false logic: if time is on or before then false If time is on or after then false else true Because in the “true” logic you loose second case after first true ---
**Author:** ![FabriMC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrimc/32/85864_2.png) [@FabriMC](https://community.glideapps.com/u/FabriMC)\ **Post date:** [April 12, 2025, 10:03pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/5 "2025-04-12T22:03:28Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/245c48678269ff91c2565d7e4ceaee6aed6bf1e3.png) Not working ---
**Author:** ![FabriMC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrimc/32/85864_2.png) [@FabriMC](https://community.glideapps.com/u/FabriMC)\ **Post date:** [April 12, 2025, 10:08pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/6 "2025-04-12T22:08:23Z")
I’ve changed it to show as time, but it still doesn’t work. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/aba0a397d4d2d8b3c238b7881d98dbf39b22347f.png) ---
**Author:** ![Chloe\_Mason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_mason/32/87120_2.png) [@Chloe\_Mason](https://community.glideapps.com/u/Chloe_Mason)\ **Post date:** [April 12, 2025, 10:16pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/7 "2025-04-12T22:16:44Z")
![Screenshot 2025-04-12 at 4.14.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5e821e82017621ba38edf901770d2883c8841e3.png) ---
**Author:** ![FabriMC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrimc/32/85864_2.png) [@FabriMC](https://community.glideapps.com/u/FabriMC)\ **Post date:** [April 12, 2025, 10:34pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/8 "2025-04-12T22:34:26Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0a3de80d16cda8335a806e04e7b14cd61c95dfb.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00709dd1cfb57b5dbeaa5d47e5931409f2b2c638.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 12, 2025, 10:36pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/9 "2025-04-12T22:36:53Z")
Oh, i see i haven’t read you question carefully. ---
**Author:** ![Chloe\_Mason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_mason/32/87120_2.png) [@Chloe\_Mason](https://community.glideapps.com/u/Chloe_Mason)\ **Post date:** [April 12, 2025, 10:41pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/10 "2025-04-12T22:41:44Z")
Try it without the template. Just use the “now” feature within the if/then/else ![Screenshot 2025-04-12 at 4.40.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2c6a39f653cfb8ad134722de531710ff6e0f78a.png) ---
**Author:** ![FabriMC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabrimc/32/85864_2.png) [@FabriMC](https://community.glideapps.com/u/FabriMC)\ **Post date:** [April 12, 2025, 10:43pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/11 "2025-04-12T22:43:29Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a22955c6ef85f5065cbe8011085d1c6b6e18cca.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46941d6777a5127e1fdb65b49039b8d403a1112e.png) ---
**Author:** ![Chloe\_Mason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_mason/32/87120_2.png) [@Chloe\_Mason](https://community.glideapps.com/u/Chloe_Mason)\ **Post date:** [April 12, 2025, 10:56pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/12 "2025-04-12T22:56:57Z")
It may be because your time start and end are set up as calculated value instead of as an actual time. Is there a reason for that? On mine, with “Time Start” and “Time End” set as an actual date and time (time only), it works how I understand you are wanting it to. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 12, 2025, 10:57pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/13 "2025-04-12T22:57:45Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4970584dd7c1a6885d12b46235c501f1c0707f13.png) This should work Start time 8:30 = 8x60+30=510 End time 22:00 = 22x60=1320 NowMinutes = Hour(NOW)x60+Minute(NOW) If NowMinutes less Start then false If NowMinutes greater End then false Else true ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 19, 2025, 10:58pm UTC](https://community.glideapps.com/t/if-then-else-for-time/81308/14 "2025-04-19T22:58:03Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.