+ Reply to Thread
Results 1 to 2 of 2

I need to subtotal times from a list where they overlap.

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Home
    MS-Off Ver
    Excel 2010
    Posts
    8

    I need to subtotal times from a list where they overlap.

    I have a column (M) that the contents are the result of subtracting a cell in column C from Column K. Now some of these numbers are positive and some are negative (#####). They are all the difference in start and stop times. These times are the start and stop of computer jobs and some run concurrently and some run after a break. So, you might have Job1 that runs from 09:00 to 09:15 while Job2 runs from 09:10 to 09:20. Essentially they took together 20 min to run (what I want) while if you added the times of each you would come up with 25 min (not what I want). Then you might have a 2 hour break and Job3 runs for 30 min, then and hour later Jobs 5-6 run from 12:00 to 14:30, 2.5 hours. These jobs are grouped in any one of 6 categories.*

    What I want to get is the "real" time it took to run all the jobs in each category and I can't get my mind around how to do it. In the example above the correct answer would be 2:30 + 0:30 + 0:20 or 3 hours and 20 minutes. I have all this information in a spreadsheet output by the software that runs it, so I can sort by category, then start time to get a baseline. I have to do this every day at end of day, so I really don't want to sift through 650 rows or so to figure it out manually.

    Thanks for any help, I'm lost

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: I need to subtotal times from a list where they overlap.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-prog...y-overlap.html
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. I need to subtotal times from a list where they overlap.
    By jtpryan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2014, 04:12 PM
  2. highlight 2 cells with times of day that overlap
    By Kshari in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-19-2014, 11:13 PM
  3. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  4. Calculate Total Time when Dates/Times Overlap
    By Steve Gilley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2008, 07:43 PM
  5. Comparing Times To Make Sure No Overlap
    By Matt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-29-2006, 11:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1