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 ...
Try wrapping your duration in Hours(). You might also have to call ToTimeOfDay on the time field, depends what type of field it is.
So something like this, as long as the duration is numeric. Might have to play around with it a bit but this should do it. I was getting some weird highlighting in QuickBase on the word Duration so you might shorten that or change it. Might not matter.
ToTimestamp([Date of Event], [Time of Event]) + Hours([Duration of Event Formula])
I'm not sure how it behaves when you feed it something like 2.5 instead of 1 or 2 so it might actually fail.
Thanks Austin. That got me halfway there. So here's what I now see. No yellow on the formula, so that's a plus. But if I have an 11AM appt for instance with a total duration of 3 hours, then the calendar shows the start time of 2pm and end of 2pm. Obviously not what I need it to show. (the 11:00am you see on the 9th next to the name is part of the "Each Day Displays" under Customize this report) I still want to show the calendar time blocked off for the time and full duration of the appointment. I think what I need is some sort of joiner to get it to show the Start time [Time of Appointment], and then calculate that the end time is the start time plus the duration [Duration Formula]. Hoping this is possible.
