+ Reply to Thread
Results 1 to 4 of 4

Need help with overlapping times

  1. 10-14-2013, 12:16 PM #1
    k.mack0215 is offline
    Registered User
    Join Date
    10-14-2013
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need help with overlapping times

    Hi!

    I need some help figuring out a formula- essentially I need to find out when times are overlapping. Once those are found- I need to count how many happen total.

    It's probably super simple-but i'm not entirely savvy when it comes to formulas.
    Zeag Report.xls


    Any help would be greatly appreciated!!

    -Kayla
    Reply With QuoteRegister To Reply
  2. 10-14-2013, 04:19 PM #2
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Need help with overlapping times

    You can use this formula in Cell M16
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 10-15-2013, 10:50 AM #3
    k.mack0215 is offline
    Registered User
    Join Date
    10-14-2013
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need help with overlapping times

    Thank you for your response!!
    I tried that- but I think my excel sheet was messed up. Here is an updated(simplified) spreadsheet.

    Again I'm looking for a formula that helps me figure out how many overlapping occurrences happen in one day.

    Any help would be great! Or if you can try and help me understand writing a formula!

    [ATTACH]271157[/ATTACH
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-15-2013, 05:21 PM #4
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Need help with overlapping times

    See the attached workbook. Using the same formula as in earlier post.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using Excel to check for overlapping times
    By evandp01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2012, 05:21 PM
  2. Overlapping in/out times- messy formulae!
    By sonyaswan in forum Excel General
    Replies: 8
    Last Post: 07-20-2012, 12:11 PM
  3. Excel 2007 : Overlapping Payroll Times
    By AM Services, Inc. in forum Excel General
    Replies: 12
    Last Post: 06-27-2012, 12:13 PM
  4. Graphing overlapping dates and times
    By fusionnv in forum Excel General
    Replies: 0
    Last Post: 11-16-2011, 01:14 PM
  5. How to show overlapping times on a schedule
    By durbancic in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2011, 11:28 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1