+ Reply to Thread
Results 1 to 2 of 2

How do I create a chart showing overlap of working hours

  1. #1
    Registered User
    Join Date
    06-08-2018
    Location
    Indiana
    MS-Off Ver
    2013
    Posts
    1

    How do I create a chart showing overlap of working hours

    Hello,
    I'm needing to create a chart with the ability to show where there is overlap in hours worked. For example, if an employee is working several places and the hours logged at each place overlap (thus the employee is fraudulently claiming time at once place that they're not actually working.) I've gotten close with Gantt charts but it doesn't show exactly what I need, which is the overlapping hours highlighted or an easy way to graphically show the impossibility of being 2 places at once. Sort of like this picture below (if it shows up/comes through.)

    work overlap schedule example.PNG

    Here is some sample data that is hopefully attaching correctly. ANY help at all is greatly appreciated!! Thank you in advance!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,815

    Re: How do I create a chart showing overlap of working hours

    Hello tfernandes818 and Welcome to Excel Forum.
    This is going to fall into the category of "any help".
    The attached file assumes that, by looking at the sample data, there would be overlaps between work place 2 and the School AM or work place 3 and School PM.
    The formulas used to find those overlaps are similar to: =AND(F3<>"",OR(F3<$C3,F3<$E3))
    Conditional formatting is applied such that if there is not an overlap the cell displays a blank, and if there is an overlap the fill (orange) and font (red) are displayed.
    As to an actual chart (gantt) I searched the web using "Excel show overlap in gantt chart" and got several youtube video results that might be applicable, including this one by Dr. O'Loughlin. I imagine that some restructuring of the data would be required in order to produce one however.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Create Schedule with Non-working hours figured in
    By halleadm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2017, 08:17 AM
  2. Calculate overlap hours
    By hamohd70 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2016, 01:33 PM
  3. Create line on chart showing current day
    By samalex in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-02-2014, 03:05 AM
  4. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  5. Create a pie chart showing two data labels
    By khenry67 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-09-2013, 03:18 PM
  6. Replies: 9
    Last Post: 02-07-2010, 06:39 PM
  7. [SOLVED] How to create a bar chart of hours worked by day?
    By mandruss in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-12-2005, 08:06 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