Overlapping or Duplicate Date & Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a chart of activities with date and time, how can I determine if
any of the date & time overlap or duplicate?
 
Let me clarify exactly what I have going on here...

Col A Col B Col C Col D Col E
Row 1 Mon 4/1/05 6/25/05 4:00 PM 6:00 PM
Row 2 Wed 4/5/05 7/1/05 4:00 PM 6:00 PM
Row 3 Mon 4/10/05 5/31/05 5:00 PM 6:00 PM

Rows 1 & 3 contain overlapping schedules (day, date, & time). Is there a
formula that will determine this from the range of cell A1:E3?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help need formula for working out date overlaps 12
Excel Catagorise AM or PM 7
Multiple row comparison to sum potentially multiple values. 2
Which is the best MBOX Converter Tool different formats conversion? 4
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Conditional Formatting for Duplicates 2
Is it possible to dedupe two excel lists? 1
Calculating Overlaps 3

Back
Top