Fix lap times copied in the wrong order for travel

You timed several travel legs, copied the lap list into your itinerary, and now the stops or arrival times do not line up. A misplaced row can make a sensible route look impossible, especially when the stopwatch recorded elapsed time instead of each leg separately.

First match each reading to the stop it belongs to. Then check whether the values are lap durations or cumulative stopwatch readings. That distinction matters: a cumulative reading marks the total time since you started, not the time spent on that one leg.

Put the laps back in travel order

1. Keep an untouched copy. Save the original lap list before editing. If you only have a copied list, duplicate it into a separate note or document so you can compare your changes.
2. Find a label for every reading. Match each lap to a stop, leg, or event using any notes you made while timing. Do not assume the current row number still matches the order in which you visited places.
3. Check what the numbers represent. Look at the stopwatch display or export labels. A lap may show time for one interval, or the elapsed total since the stopwatch started. If the readings increase from one line to the next, they may be cumulative.
4. Rebuild the route in sequence. Put the named stops in the order you actually traveled, then attach the matching reading to each one. If you cannot identify a reading confidently, mark it as uncertain instead of assigning it by guesswork.

For example, if cumulative readings are 00:48:00 at Stop A and 01:35:00 at Stop B, the time between those marks is 47 minutes, not 1 hour and 35 minutes. Subtract the earlier elapsed time from the later one to get the leg duration.

What the readings mean

The times keep getting larger

This often means the stopwatch recorded cumulative elapsed times. Subtract each reading from the one before it to estimate the time for the next leg. Keep the first reading as the first interval if the stopwatch began at the start of that leg.

The times are separate short durations

These may already be lap or split durations. Use each value as the time for its labeled leg, rather than subtracting it from the previous one. Check the stopwatch's display labels or saved record before doing arithmetic.

The schedule jumps backward or crosses midnight

Elapsed duration and clock time are different. A 90-minute leg starting at 11:30 p.m. ends at 1:00 a.m. the next day. Write the date as well as the time for overnight travel. If the route crosses time zones, record which local time zone applies to each stop.

A number has no reliable stop label

The value alone cannot tell you where it belongs. Check handwritten notes, messages, tickets, or other records from the trip. If there is no clear match, leave that leg as an estimate and avoid presenting the measurement as exact.

How to repair the itinerary

1. Sort by the route, not by the displayed time. Start with the planned travel sequence: departure, transfers, stops, and destination. Sorting numeric times can put a later leg before an earlier one, and sorting values stored as text can produce an even less useful order.
2. Convert cumulative readings to intervals. Subtract each previous elapsed reading from the next. For example, 01:35:00 minus 00:48:00 is 00:47:00. Do not subtract when the source already reports separate lap durations.
3. Separate travel time from stop time. A lap measured between two marks may include a wait, a transfer, or time spent at a stop. If you recorded those events separately, list them as separate parts of the itinerary instead of treating the whole interval as driving or walking time.
4. Recalculate clock-time arrivals from the departure. Add each leg duration and planned stop to the time before it. Check the date after midnight and the local time at each location when crossing a time zone.
5. Compare the finished list with the original. Confirm that every stop appears once, every lap is accounted for, and no reading was accidentally copied twice or omitted. Keep the original measurements nearby until the schedule makes sense.

Make the plan useful, not falsely precise

A measured lap is a record of one trip under particular conditions. It may include traffic, waiting, a missed connection, or a long stop. Treat it as a reference, not a promise that the next journey will take exactly the same time.

For a practical plan, start with the measured leg duration, then add a buffer for the parts that can vary. Use a larger buffer for transfers, border checks, busy roads, or connections that would be costly to miss. Keep the measured duration and planned allowance in separate notes so it is clear which number came from the stopwatch.

If you are still unsure which lap belongs to which stop, preserve the uncertain values and label them clearly. A realistic estimate is more helpful than a perfectly formatted itinerary built on a guess.