# Conditional calculated time column

**URL:** <https://community.glideapps.com/t/conditional-calculated-time-column/61276>\
**Category:** Ask for Help\
**Created:** [May 2, 2023, 7:41pm UTC](https://community.glideapps.com/t/conditional-calculated-time-column/61276 "2023-05-02T19:41:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chessdr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chessdr/32/58186_2.png) [@chessdr](https://community.glideapps.com/u/chessdr)\
**Post date:** [May 2, 2023, 7:41pm UTC](https://community.glideapps.com/t/conditional-calculated-time-column/61276/1 "2023-05-02T19:41:02Z")

</div>

I’m trying to develop an interview application. These interviews start, say, every Wednesday at 6:30 p.m. and last for 10 minutes. However, there could be 1-3 interviewees on a given week. I envision the start time and number of interviewees as a couple of variables/settings. Then, when an appointment is scheduled (added), if there were two interviewees, I would input 6:30 into the date column for the first two interviews and then 6:40 for the 3rd & 4th interviews, etc. I’m struggling with where/how to do this calculation?

---

<div class="post-metadata">

**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:** [May 3, 2023, 12:11am UTC](https://community.glideapps.com/t/conditional-calculated-time-column/61276/2 "2023-05-03T00:11:50Z")

</div>

So what you want to do is a form where you can add multiple rows for consecutive interviews?

---

<div class="post-metadata">

**Author:** ![chessdr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chessdr/32/58186_2.png) [@chessdr](https://community.glideapps.com/u/chessdr)\
**Post date:** [May 3, 2023, 12:27am UTC](https://community.glideapps.com/t/conditional-calculated-time-column/61276/3 "2023-05-03T00:27:22Z")

</div>

Correct!
