If blank = Time of Day Field + 1 Hour
I followed another thread and was successfully able to create time blocks in a calendar report. However, because I created a new field for moving forward, I have thousands of records without any data...
Forum Discussion
The formula you have is a good start - something like:
IF ( isnull([Appointment Estimated End Time]), [Appointment Start Time] + Hours (1), [Appointment Estimated End Time])
where it will add 1 hour to start if there is no end time, else use the end time.
------------------------------
Chayce Duncan
------------------------------