Formula for Calendar Time Block (Start Time + Duration)

Thank you so much! This worked like a charm!! For future reference for anyone else who needs help with this, here's what I did.

My Form:


Start Date And Time:

End Date & Time



Calendar Events Report:

Hi Coach,

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...

When you set up the calendar report it is looking for the two fields to use for the start and the end of the appointment.

So you will want to have a Time stamp formula date/time field for the start of the appointment which combines the start date and start time, and then formula date/time field for the end date time.



The start date/formula would be called perhaps [Start Date/Time] 

ToTimestamp([Date of Event], [Time of Event])

[Start Date/Time] + Hours([Total Duration])