+ Reply to Thread
Results 1 to 2 of 2

Time Slot Reservation Form

  1. #1
    Registered User
    Join Date
    03-30-2017
    Location
    Atlanta. GA
    MS-Off Ver
    Office 2016
    Posts
    1

    Question Time Slot Reservation Form

    At work, we have 12 people sharing 4 accounts for a web service that doesn't allow multiple people logged on at the same time. So, we have to send out an email declaring that we are using X account until X:XXPM. I want to make a shared excel sheet for people to input their times. I have a chart with times in 15 minute increments on the y axis, and the 4 account names across the top on the x axis. Ideally, I would like to create a system where you choose an account to log on to, and an allotted time frame (30 minutes/1 hour) and it updates the chart automatically. It doesn't need to say who is using the account or anything, just that an account is being used. Any help would be greatly appreciated! I have a very basic command of excel so I could be thinking way too complex here but I figured, what the heck? worth a shot.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Time Slot Reservation Form

    Try this :

    Paste this code into the Sheet level module ...

    Please Login or Register  to view this content.
    The method of click / drag a range to change colors is cumbersome. Use of the command buttons is a sure thing.
    Attached Files Attached Files
    Last edited by Logit; 03-30-2017 at 08:34 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I wish to make a time slot
    By oO P2K Oo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2016, 12:27 PM
  2. How to calculate workers assigned to time slot?
    By Sev129 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-12-2014, 11:30 AM
  3. Insert Rows automatically after every time slot
    By cyee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2013, 01:44 AM
  4. Excel time slot booking system
    By genichigo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 09:23 AM
  5. [SOLVED] Calculating longest waiting time at given time slot
    By dvs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2013, 06:20 PM
  6. Replies: 1
    Last Post: 03-28-2012, 12:11 PM
  7. Return cell contents during a time slot.
    By Pompano Tom in forum Excel General
    Replies: 2
    Last Post: 03-22-2007, 08:45 AM

Tags for this Thread

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