Reply to thread

Message

[QUOTE="drum118, post: 3356370"]
<snip>
The problem I see is "Bus Departs at" will always be in col O (15) all
the time for "Stop #" can be anywhere between col T to DD depending on
the book. Some have only 25 "Stop #" will other may have up to 55.
Placing RunTime various from numbers for them to locations of them in
various books.

I want to know how long it took from first record time to the last
record time requiring a RunTime. Runtime is use to calculate the
operating cost of the bus. So I would have something like this:

Col O     R       S      Z          AA       AD      AE          BB  BC
Depart  Stop     Run       Stop    Run     Stop      Run        Stop Run
0:00:00  0:00:00 0:00:00  0:00:00  0:00:00  0:00:00 0:00:00 0:00:00
0:00:00
0:00:00 07:30.55 0:00:00 07:55:55  0:20:00 08:11:33 0:40:38 8:15:22
0:44:27
0:00:00 0:00:00  0:00:00  0:00:00 14:22:12 14:44:44 0:22:22 0:00:00
0:00:00
0:00:00 19:12:12 0:00:00  19:33:33 0:19:19  0:00:00 0:00:00 0:00:00
0:00:00
12:12:12 12:13:23 0:01:11 12:22:33 0:20:11 12:44:44 0:32:32 13:23:33
01:09:11
Cells are formatted as 15:13:00 using 24 clock.

All I had to do with my script was use =RunTime(xx) in the cell I wanted
a RunTime enter.

Want to make sure on the first 2 before I start building 160 books and
about 200 rows per book min.

Just making sure on your =RunTime($O$6:$dd$6,O7:DE7) Row 6 has the text
info, row 7 to 200 will have the data.
[/QUOTE]

Verification