Results 1 to 4 of 4

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

Threaded View

  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

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. 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