Time Math

  • I have a series of multiple train routes that come to the same terminus, before a transfer. I am trying to calculate total travel duration. Since every train arrives at a different time - utilizing one example, If I have a train arrival time of 8:37, and my connection is at every ten minutes on the 0:04 (meaning 8:24; 8:34; 8:44, etc), how would I automatically calculate the time difference, if I were trying to add the wait time to total duration of my trip?

    The minute function calculates all the means (in the 10's column and the 1's column, so I can't do a min/max to determine which to subtract from)

    Any help would be appreciated.