+ Reply to Thread
Results 1 to 2 of 2

Lunch & Break Timetable

  1. #1
    Registered User
    Join Date

    Lunch & Break Timetable


    I am looking to construct a table with 5 different shift patterns for 12 different employees, and dependant on what shift pattern they are in will show what break / lunch they should take.

    basically - shifts are:

    07:30 - 15:30
    08:00 - 16:00
    08:30 - 16:30
    09:00 - 17:00
    09:30 - 17:30

    and along the top row would be Monday - Friday

    If I made a drop down list of employee names for each corresponding timeslot of each day, I want a table below that would show "if employee is on shift 1 then their break is 1st of the day" and so on. Therefore, as shift patterns rotate for employees it will print a separate table each week showing the breaks, Which would automatically update if the shift pattern changed.

    Im reckoning its VLookup but Im just looking for guidance

    thanks in advance for any help that may be offered

  2. #2
    Valued Forum Contributor
    Join Date
    Eastbourne, England
    MS-Off Ver
    Excel 2010

    Re: Lunch & Break Timetable

    Hi ayrshiredj

    Welcome to the forum.

    I believe that the attached (using vlookups) may be your answer.

    Note that the "iferror" statement does not work on pre-2007 versions of Excel (and you have not stated what version you are using.

    Let me know if I have interpreted your situation correctly.

    Attached Files Attached Files

+ 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. lunch break times
    By exodus27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2014, 06:48 PM
  2. [SOLVED] Automatically exclude 1 hour lunch break
    By samaine in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-16-2013, 12:20 AM
  3. Can't pull someone's lunch and break at a given time
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2013, 09:01 AM
  4. Lunch Break Timings Calculations
    By paulmichaelfarrow in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 09:40 AM
  5. Calculating time, potential lunch break
    By B1123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-13-2008, 09:18 AM


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