Results 1 to 4 of 4

Thread: Need formula for Elapsed Time (negative values, times after midnight)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2016
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need formula for Elapsed Time (negative values, times after midnight)

    Hello,
    I need to calculate how minutes late/early a train arrived (elapsed time) by comparing the scheduled arrival time with the actual arrival time. I have tried many different ways of doing this, but none of the ways seem to work for all four scenarios I've encountered with the data. Please note that I must keep the 1990 date system (Windows default). Also, I need to keep the results in numeric values that I can use to do future calculations with. The same formula must work for all four scenarios. Please see below (I don't know how to attach the actual Excel sheet).

    Scenario Scenario Description Minutes Early/Late Scheduled
    Train Arrival
    Actual
    Train Arrival
    1 Train was late 7.00 8:58 AM 9:05 AM
    2 Train was early (2.00) 5:50 PM 5:48 PM
    3 Train was exactly on-time (0.00) 7:07 PM 7:07 PM
    4 Train arrived after midnight. (1,383.00) 11:03 PM 12:00 AM
    Scenario 4 should result in 57 minutes late, not 1,383 minutes early.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    227
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Need formula for Elapsed Time (negative values, times after midnight)

    You seem to have duplicated the question. Pease see my response to your later submission here: https://www.mrexcel.com/forum/excel-...ml#post5334408
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    New Member
    Join Date
    Dec 2016
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula for Elapsed Time (negative values, times after midnight)

    Thanks, Toadstool. I am new to Mr. Excel and I accidentally posted in the wrong forum at first. I will delete this post above.

  4. #4
    New Member
    Join Date
    Dec 2016
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula for Elapsed Time (negative values, times after midnight)

    Actually, I don't know how to delete it! Sorry for the double post.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •