The approach in this thread looks wrong to me considering your example. Your
example shows you have random time periods between 6AM and 6 PM for
appointments. Appointment 1 is 1-1/2 hour, Appointment 2 is 3 hours and
Appointment 3 is 1 hour. It is only by coincidence (or common practice)
that the appointment start and end times fall on what looks like the quarter
hour. Actually your example shows appointment start and end times fall on
the half hour. If the above is true, unused time slots are:
6 AM to 6 PM if no Appt 1
Appt 1 end time to Appt 2 start time or 6 PM if no Appt 2
Appt 2 end time to Appt 3 start time or 6 PM if no Appt 3
Appt 3 end time to Appt 4 start time or 6 PM if no Appt 4
Steve
"Wayne" <cqdigital@volc anomail.comwrot e in message
news:04df1ed6-8bc9-4605-b837-d42e9ba01e49@n1 4g2000pri.googl egroups.com...
example shows you have random time periods between 6AM and 6 PM for
appointments. Appointment 1 is 1-1/2 hour, Appointment 2 is 3 hours and
Appointment 3 is 1 hour. It is only by coincidence (or common practice)
that the appointment start and end times fall on what looks like the quarter
hour. Actually your example shows appointment start and end times fall on
the half hour. If the above is true, unused time slots are:
6 AM to 6 PM if no Appt 1
Appt 1 end time to Appt 2 start time or 6 PM if no Appt 2
Appt 2 end time to Appt 3 start time or 6 PM if no Appt 3
Appt 3 end time to Appt 4 start time or 6 PM if no Appt 4
Steve
"Wayne" <cqdigital@volc anomail.comwrot e in message
news:04df1ed6-8bc9-4605-b837-d42e9ba01e49@n1 4g2000pri.googl egroups.com...
Is there a simple way to do the following? Assuming that the working
day is 6am to 6pm and appointments are booked throughout the day for
example: 8:00am - 9:30am, 10:00am - 1:00pm, 2:00pm - 3:00pm.
>
How would I go about displaying the unused time slots i.e. 6:00am -
8:00am, 9:30am - 10:am, 1:00pm - 2:00pm and 3:00pm - 6:00pm?
day is 6am to 6pm and appointments are booked throughout the day for
example: 8:00am - 9:30am, 10:00am - 1:00pm, 2:00pm - 3:00pm.
>
How would I go about displaying the unused time slots i.e. 6:00am -
8:00am, 9:30am - 10:am, 1:00pm - 2:00pm and 3:00pm - 6:00pm?