+ Reply to Thread
Results 1 to 4 of 4

Timetable - 24hr type - booking hours conflicts for one worker from many.

  1. #1
    Registered User
    Join Date
    04-18-2019
    Location
    Ireland
    MS-Off Ver
    2019
    Posts
    3

    Timetable - 24hr type - booking hours conflicts for one worker from many.

    Hello everyone!

    For a few weeks now I have been struggling and torturing myself with a very difficult problem.
    There is very little about it on internet and if there is - it is not the relevant one... I couldn't find it at least...

    My problems basically is:
    The business sends workers to many different addresses through out the day.
    There are many workers.
    Jobs are limited by time (start and end).
    The schedule is done for a few days ahead.

    However:
    If one or more of the jobs given to the same worker on one day overlap/conflict with each other I need it to highlight those addresses.

    A little explanation
    I know we can manually notice those overlaps by using of the table filters but that is not the type of solution that I am looking for.

    I have attached a picture with a prototype of this type of a problem:
    QUESTION ON INTERNET.JPG
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Timetable - 24hr type - booking hours conflicts for one worker from many.

    Hi

    To simplify I add two columns for your table to get a real date-time start/end.

    In M4 use the following formula and copy down and forward
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Numbers represent table rows where conflicts exist.
    See the file
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-18-2019
    Location
    Ireland
    MS-Off Ver
    2019
    Posts
    3

    Re: Timetable - 24hr type - booking hours conflicts for one worker from many.

    Hi Sir,

    Your solution worked fantastic!

    I just wanted to say thank you so muchhh! You literally saved me! I love you!

  4. #4
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Timetable - 24hr type - booking hours conflicts for one worker from many.

    You are welcome. I'm happy to have helped.

    Please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Thanks.

+ 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. Calculate total hours worked in week by worker name
    By evgemans in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-23-2019, 12:24 PM
  2. [SOLVED] how to calculate hours worked using 24hr clock
    By will2k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2014, 07:43 PM
  3. Total Hours worked per Job or Worker
    By DJohnson2 in forum Excel General
    Replies: 2
    Last Post: 07-19-2012, 11:10 AM
  4. Calculating Total Hours Between Two Times Past 24hr
    By BM4193 in forum Excel General
    Replies: 3
    Last Post: 09-18-2009, 09:21 AM
  5. working hours (24hr format)
    By ulqin in forum Excel General
    Replies: 4
    Last Post: 07-14-2009, 06:35 AM
  6. [SOLVED] how do I round hours worked to the next half hour with a 24hr shif
    By gycoso3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2006, 04:30 PM

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