+ Reply to Thread
Results 1 to 2 of 2

Calculating Time Between 2 events that cross Midnight

  1. #1
    Registered User
    Join Date
    06-25-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Calculating Time Between 2 events that cross Midnight

    I have a spreadsheet that tracks system outages. I am trying to automatically track the duration of time in minutes that has elapsed between the start time and end time. The spreadsheet is set up using four columns: 1. Start Date 2. Start Time 3. End Date 4. End Time
    There are no problems if the outage occurs within the same date. However if the dates vary, such as a start date/time of 6/1 at 7pm and an end time of 6/2 at 3am I end up with bad data. I am attaching a mock copy of what my sheet looks like.

    I am sure that this is probably something simple that I am overthinking.

    Thanks in advance to any and all that contribute.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Calculating Time Between 2 events that cross Midnight

    What about by trying this on E2:

    =((C2+D2)-(A2+B2))*24*60

    You can modify it a bit then so that it tell you hours and minutes. Tell us if you require that.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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