Formula for Calendar Time Block (Start Time + Duration)
I have what I think is a simple question, but I cannot create a working formula. I need to have blocked off times for individuals on a calendar. I have an event start time for individuals in a form ...
Eli, Can you tell me your formula for your end date/time? It seems to me from your post that you made a formula for the start date/time when you wanted to make a formula for the end date/time.
Please forgive me, I am new to Quickbase and formulas, so I appreciate your help. Right now it's a lot of trial and error.
I don't have a set 'end time' on my form. I use a duration on my form.
I have a beginning time of the appointment, and an entry for the duration of the appointment. And I need the calendar to block that time for the client from beginning to end of the appointment.
This is my duration field that is on the form. It is numeric.
This is my Duration Formula, which is just pulling the Total Duration (so I guess it's basically redundant)
And this is my formula I'm trying to use to block of the time on the calendar. The start time is a formula combining the Date of Appointment field from my form and the separate Time of Appointment field. Hope that makes sense...
