Results 1 to 8 of 8

booking time slots

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    bradford
    MS-Off Ver
    Excel 2010
    Posts
    92

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. booking time issues if booking removed
    By peter renton in forum Excel General
    Replies: 0
    Last Post: 04-11-2014, 03:50 AM
  2. [SOLVED] calculating hours using scheduled workers and time slots.
    By Darkflame808 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-05-2013, 03:44 AM
  3. [SOLVED] Grouping of time slots in Excel 2010
    By Doctor Gooose in forum Excel General
    Replies: 4
    Last Post: 06-20-2012, 03:32 AM
  4. [SOLVED] calculating a time range into predefined time slots
    By DamianWarS in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 07:26 AM
  5. [SOLVED] counting time slots
    By Nick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1