booking time slots

Hi

Not sure if this can be done.

At the moment the attached booking sheet adds the allocated hours to complete the mot in column b and adds the next available time slot in the cell below.
this has to be done in order so that it knows the next time.
Is there a way to allow me to book one in at say 9.00am to 9.55 and then the next booking taken might be for 11.30 am then the one after that at 10.00 (or any time) and still be able to work out that between 9.55 and 11.30 i can still book in a 1.35 hour job?

Also if a booking is cancelled it would just re set the time available and if the booking wants moving the booking data could be easily transfered??

Does anybody know of an example time booking code that i might be able to adapt for my wb?
I still need to select the type of test which has a time attached to it, but i would like to beable
to add the booking to any available time slot, or remove a booking making that time slot available again.

in theory we could have 12 five minute re test booking in one hour or a 55 min full test then a 5 min re test
or any number of different bookings .
at the moment each booking has to be in order as the times look at the on before and add up the next start time
but this all falls down if a booking is removed or a booking is wanted at 11am and theres nothing booked before it.

The calender booking works well its just allocating time slots thats the pain

If some kind guru could assist me in this i would be grateful

Hi

Does anybody know if this type of time allocation can be done within excel programing or should i be
looking at it a different way?
Any guidance would be appreciated

Cheers
Peter

Hi
I am upto and well passed my limits of Knowledge to complete this :-) could some kind sole
get me started with some code that i could continue with ?

Cheers Peter

hi peter

through the calendar I added a new sheet for today's date

made changes to formula used in column B

=IF(I4="","",IF(ISNUMBER(INDEX($I$3:$I3,MATCH(24,$I$3:$I3))),INDEX($B$3:$B3,MATCH(24,$B$3:$B3))+INDEX($I$3:$I3,MATCH(24,$I$3:$I3)),""))

this now copes when there are blank rows, it will look for the latest values in columns B and I

(when you open the attached file it will become clearer)

in the current format there are only 11 slots available, does this need increasing ?

32

Hi 3
Thank you for looking at this, your amendedment certainly works better than my original effort.

I have attached the wb with what i would ideal like shown on may 14th tab.


I have added times of 5 minute itervals in column a, i would like to add a test type at the side of 8am
and if the allocated time in I was 30 mins this would grey out time slots from 8 to 8.25 highlighting that this is booked and the next available booking could start at 8.30.

If then next booking was for 9.00 with a slot of 55 mins this would do the same etc.

If the test was cancelled or moved it could be deleted without efecting the other enteries

your thoughts would be appreciated

Regards

Peter

Dear Experts!

For our warehousing operations, I am creating a time slots booking sheet in excel - or at least attempting to do so. Simply said, we have thee operating Warehouses (1,2,3) and time slots from 07:00AM till 18:00PM, whereas we can handle one truck/hour/warehouse.
Got as far as the attached worksheet, but the formula (IF+AND) doesn't seem to work for all the data (array in C3:C20).
What I would need the formula to do is:
first check if the requested time slot (B3:B20) is corresponding to time slots in E2:O2, then search for the requested warehouse (C3:C20 in array D3:D5), and if requested time slot is free, time slots corresponding to the requested will get filled in with truck reg.nr (A3:A20).

Hope this is somewhat clear, would love to see the final solution here!

All the best,
CtB

You should not attempt to hijack someone else's thread (see Rule 04 in the Forum Rules at the top of the screen). Instead, you should start your own thread with a link back to this one if you think it is relevant.

Pete