+ Reply to Thread
Results 1 to 1 of 1

Can't pull someone's lunch and break at a given time

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 2007
    Posts
    244

    Unhappy Can't pull someone's lunch and break at a given time

    Team, Is there a Macro that can be used to display someone who is on lunch at a given time?. I am working on an adherence tracker which has a live view so the Manager on duty can look and see who is on lunch at 2:00 pm. I've attached the sheet. There are 49 persons and I want the the live view sheet to display who is on lunch or break at either 2:00pm or 3:00pm. I was trying to use a vlookup but somehow its not working. Help!!!! anyone.
    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. Replies: 7
    Last Post: 04-25-2020, 03:23 AM
  2. Lunch Break Timings Calculations
    By paulmichaelfarrow in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 09:40 AM
  3. Replies: 0
    Last Post: 08-21-2010, 08:03 AM
  4. Calculating time, potential lunch break
    By B1123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-13-2008, 09:18 AM
  5. Overtime computation and lunch break formula with IF and AND
    By navychef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-08-2005, 03:15 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