Forum Discussion

EliCorp's avatar
EliCorp
Qrew Trainee
6 years ago

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 ...
App builders
Formulas and functions
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
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.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
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])