Office Clinic Patient Registration Booking

AngB789

1. I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time slot. Ultimately if a patient checks in they would then be assigned to a room during registration.

2. Is there any solutions someone has found on creating this?

3. Is there a way to take the end time from the first row, automatically place it in the start time on the second row and then have a formula to calculate 30 minutes from there to get the next end time?

Paul Newcome

Your screenshot didn't come through.

AngB789

@Paul Newcome I just update my entire question. Sorry for that confusion. My screen auto refreshed, and it submitted everything I had at the time.

Paul Newcome

If you insert a text/number column (called "Slot Number" in this example) and then manually enter the numbers 1 through however many time slots there are, you could then use this to start at 8:00am:

[Start Time]:

=((8 + INT(([Slot Number]@row - 1) / 2)) - IF(8 + (([Slot Number]@row - 1) / 2) > 12, 11, 0)) + ":" + IF(ISODD([Slot Number]@row), "00", "30") + IF(8 + (([Slot Number]@row - 1) / 2) >= 12, " PM", " AM")

[End Time]:

=((8 + INT(([Slot Number]@row) / 2)) - IF(8 + (([Slot Number]@row) / 2) > 12, 11, 0)) + ":" + IF(ISODD([Slot Number]@row), "30", "00") + IF(8 + (([Slot Number]@row) / 2) >= 12, " PM", " AM")