1. L

    Total Time Less Lunch Overlap

    Hello is there a way to adjust the formulas in Column I so that if the times overlap the lunch break (12 pm to 12:30 pm) it deducts that time? I have the Lunch In L12 and Lunch Out L13 if that matters. So it should be a 30 minute break. The result of the new formula would then be I5 2.5...
  2. R

    Column Chart - columns overlapping Y axis

    I have eight data points in a column graph, ranging from -13.9% to +4.5%. The Y axis of zero is in the middle of the chart. The columns overlap the Y axis, and this overlap grows as the column width is increased. At a 1 column width, there is no overlap. At a width of 5, there is a light...
  3. D

    Identify Overlapping Times with Multiple Criteria

    I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping. I have two fields for...
  4. K

    Exclude Overlap between date and time in excel and calculate Down Time

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I J K L M </thead><tbody> 2 SN. #B4C6E7[/URL] , align: center"]A #B4C6E7[/URL] , align: center"] DT #FFFF00[/URL] , align: center"]Actual DT...
  5. M

    catch and report overlap times

    Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you <colgroup><col width="64" style="width: 48pt;" span="5"> <col width="78" style="width: 58pt...
  6. M

    Formula To Calculate Dates That Overlap

    Morning all, Another little piece of help required please, this time regarding dates/times that overlap. Example Data: I need to calculate the number of days overlapping within the data for each unique Name. <tbody> Name (A) Start (B) End (C) Dave 08/02/2018 09:00 08/02/2018...
  7. T

    Please help! 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...
  8. S

    Two Time Ranges, Count and List of Hours That Overlap

    Hello, I have two time ranges that are somewhere between 0-24 (this can loop around as well, such at a time that starts at 17 and ends at 6). I need to be able to have excel tell me what hours overlap between these time ranges, and also tell me the total number of hours that overlap. The data...
  9. G

    Radar Charts

    Hello, How do you move labels on a radar chart? I have 45 "Pie" slices that have a description for each and they are illegible at twelve and six o'clock positions. The labels overlap each other. Is there a way to separate the labels a bit further or change their axis to be radial instead of...
  10. C

    Comparing two range of dates

    Hey everyone, So I have a bit of a conundrum with a code I've been working on. So currently I have this code running: Option Explicit Public SelectItem3 As String, pos3 As Long Private Sub AddDate() Dim b As Object, RowNumber As Integer Set b = ActiveSheet.Buttons(Application.Caller)...
  11. R

    Comparing two columns using Match Function (Approximate)

    I am trying to compare two columns, each of which contain company names. The list is over 6,000 rows so I would like to use a function and drag it down. Normally, you would use the Match function, but the problem is the company names are slightly different. Example: Column A...
  12. 0

    Error message- this selection isn't valid. Mske sure the copy and paste areas dont overlap

    Getting this message when trying to create a name from a selection. I have not copied anything.
  13. M

    Formula to highlight overlapping dates within a criteria

    Hi I'm struggling to adapt a formula I currently have which helps indicate overlapping dates. I need to adapt this into a conditional formatting technique please. The table below shows an employee's employment record in a company: <tbody> A B C D E F 1 2 Record Start Date End Date...
  14. N

    Odometer/Mileage Chart with Two Gauges

    Hello, I am trying to create an odometer chart which I've successfully done using one of several online posts on this topic (combining a doughnut and pie chart). However, I'd like two have two 'needles' on my chart. I've added a second pie graph to do this but the problem is, my needles won't...
  15. D

    Plot labels not showing up

    Hi, I have plotted a 2 x 2 according to the instructions here: How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success ...but I'm encountering some problems: 1) Not all of the labels are showing up for all of the dots on the map - any idea why this is...
  16. K

    Count overlapping times on a moving 30 min window

    I searched the forums for a similar question and did not see one that helped with this question. I need to know on average how many airplanes are on the ground at the same time during the day. To get an accurate number it needs to look 30 minutes ahead of and behind the departure time and...
  17. G

    Overlapping formulas - VBA

    Hi, I'm having a problem with this code. I have the formulas right and the filters aswell, the problem is although I select only visible cells, the formulas are overlapping each other and I'm losing the ones that I wrote before. Is there any way I can concatenate formulas or just select the...
  18. D

    Compare 2 item arrays if they overlap with other 2 item arrays in those two columns

    Hi everyone. I am new on the forums so please point out any error I make in the process. I work with Excell 2010 SP1 on Windows 7. I need help with finding if any 2 horizontal sets of numbers next to each other overlap with other sets in same two columns. Numbers are cumulative times group of...
  19. A

    Return offset value of overlapping values to a single cell

    Hello! Excel version: 2010 I'm trying to compare a value range from a unit in a table with every other unit in that table to find out if there are any overlapping value ranges. The range to compare consist of a minimum value and a maximum value. If one or more range overlaps are found, the...
  20. F

    Percentage Overlap

    I'm looking at a consortium of databases which are all representative of the country (little to no skew in each database). Adult population in the country is 48m. The databases in order of size: 19m 12m 4m 4m 4m 3m 1m 0.5m 0.5m I'm trying to calculate the net number of records I'm likely to...

Some videos you may like

This Week's Hot Topics