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")

AngB789

@Paul Newcome That was very helpful. I have one more question for you. Say I do 24 hours when I get to 24:00 it shows as PM. Is there something I should also add to the formula?

Also, hopefully last thing I would like to reference a different master sheet which would be the slots sheet to return the slot number on my patient list, to be able to show that something has been booked which could include more than 1 slot number if it is more than a 30-minute time slot.

Patient List with a formula to generate the total start and end time together with the slot number(s) I would like to pull from the master Slots/time list.

Master Time Slots Sheet: