Closed Thread
Results 1 to 2 of 2

Scheduling Appointments

  1. #1
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    Scheduling Appointments

    Hi,

    Can someone derive formulas to post appointments to the Weekly Schedule sheet from the Appointments sheet please?

    There needs to be travel time from cell E3 between appointments. I manually entered the appointments with different fill colors showing the duration.

    The lunch hour should be designated from the Appointments sheet M1 & M2.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Scheduling Appointments

    You are now trying my patience.

    Your previous thread https://www.excelforum.com/excel-gen...ng-issues.html by definition and subject title was all about time scheduling and involved your Appointments sheet

    This request to populate a weekly schedule from your appointments sheet is an extension to the workbook in your existing thread and therefore you should continue in that thread. Accordingly I am closing this thread.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Outlook appointments VBA
    By sara1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2015, 07:26 AM
  2. Scheduling: Calendar style scheduling based on scheduling list
    By denkatprieto in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-19-2012, 11:10 AM
  3. Excel VBA and Outlook appointments
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2011, 12:00 PM
  4. Automaticly create Appointments from XL
    By zbor in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2009, 03:47 AM
  5. Adding appointments
    By timbim in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2009, 03:18 PM
  6. appointments in Outlook from Excel
    By each in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2007, 08:11 AM
  7. get Outlook calcendar appointments
    By gabch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2006, 05:44 PM

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