Making a timer which lap times and splits

[Danield439]

I have an off road race coming up in one week, and wanted to develop a worksheet which keeps track of lap times, and from that do splits to see who is leading the race. The way we have done it in the past is by hand with a piece of paper and a stop watch. all the cars start 30 seconds apart so if there is 10 cars, the first car will have a 5 minute lead in physical position, but doesn't mean he is in the lead (time wise). So this time needs to be adjusted to accommodate the difference in start times. I have limited experience c+, or excel macros. does anyone have a simple solution, worksheet, website ect. that can help me out. Formulas are no problem, but the coding of timers is tricky because i can't get the timer to keep running when i try to start a nother timer.

Also, the race is 250 miles, 5 laos at 5o miles a lap. There will be 50 cars.
Would it be more practical to make a sheet where i did use a stopwatch, and just imputed real time and just write a formula to correct time?

Thank you!!!

Daniel Deen
<table border="0" cellpadding="0" cellspacing="0" width="968"><col style="width: 48pt;" width="64" span="6"> <col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64"> <col style="width: 99pt;" width="132"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 76.5pt;" height="102"> <td style="height: 76.5pt; width: 48pt;" width="64" height="102"> <table border="0" cellpadding="0" cellspacing="0" width="968"><col style="width: 48pt;" width="64" span="6"> <col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64"> <col style="width: 99pt;" width="132"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 76.5pt;" height="102"><td class="xl24" style="border-left: medium none; width: 48pt;" width="64"> <table border="0" cellpadding="0" cellspacing="0" width="968"><col style="width: 48pt;" width="64" span="6"> <col style="width: 71pt;" width="94"> <col style="width: 48pt;" width="64"> <col style="width: 99pt;" width="132"> <col style="width: 48pt;" width="64" span="3"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 76.5pt;" height="102"> <td class="xl26" style="height: 76.5pt; width: 48pt;" width="64" height="102"> </td> <td class="xl26" style="border-left: medium none; width: 48pt;" width="64">255 miles</td> <td class="xl26" style="border-left: medium none; width: 48pt;" width="64"> </td> <td class="xl26" style="border-left: medium none; width: 48pt;" width="64"> </td> <td colspan="8" class="xl24" style="border-left: medium none; width: 458pt;" width="610">Timer</td> <td class="xl26" style="border-left: medium none; width: 77pt;" width="102"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17">car #</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Start time</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;">lap 1</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">TT 1 laps</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">lap 2</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">TT 2 laps</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">lap 3</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">TT 3 laps</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;">total time</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Average MPH</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17">1600</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">8:00:00</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl25" style="border-top: medium none; border-left: medium none;">55:33</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">55:33</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">52:15</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">1:47:48</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">etc..</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">tt2laps+lap3</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17">1601</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">8:00:15</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl25" style="border-top: medium none; border-left: medium none;">54:30</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">55:33</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">51:55</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">1:47:28</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">etc..</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">tt2laps+lap4</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17">1602</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">8:00:30</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl25" style="border-top: medium none; border-left: medium none;">52:13</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">55:33</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">56:12</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">1:51:45</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">etc..</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">tt2laps+lap5</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; border-top: medium none;" height="17">1603</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">8:00:45</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl25" style="border-top: medium none; border-left: medium none;">56:52</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">55:33</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">57:15</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">1:52:48</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">etc..</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">tt2laps+lap6</td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table></td><td class="xl24" style="border-left: medium none; width: 48pt;" width="64">
</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">
</td> <td colspan="8" class="xl25" style="border-left: medium none; width: 458pt;" width="610">
</td> <td class="xl24" style="border-left: medium none; width: 77pt;" width="102"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">total time</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Average MPH</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" height="17">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" align="right" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" align="right">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" align="right" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" align="right">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" align="right" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" align="right">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; border-top: medium none;" align="right" height="17">
</td> <td class="xl26" style="border-top: medium none; border-left: medium none;" align="right">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl24" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table></td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td colspan="8" class="xl22" style="width: 458pt;" width="610">
</td> <td style="width: 77pt;" width="102">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">
</td> <td class="xl26" align="right">
</td> <td>
</td> <td class="xl24">
</td> <td class="xl23">
</td> <td>
</td> <td class="xl25">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">
</td> <td class="xl26" align="right">
</td> <td>
</td> <td class="xl24">
</td> <td class="xl23">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">
</td> <td class="xl26" align="right">
</td> <td>
</td> <td class="xl24">
</td> <td class="xl23">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="right" height="17">
</td> <td class="xl26" align="right">
</td> <td>
</td> <td class="xl24">
</td> <td class="xl23">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>

 

[Gerald Higgins]

Would it be more practical to make a sheet where i did use a stopwatch, and just imputed real time and just write a formula to correct time?

I'm not an expert in this but I would think this is absolutely the right way to go about it.

I mean you could also go for high tech solutions such as tracking each car by GPS or RF chips or something, but you probably don't have time to set that up, if you're not already planning to.

 

[kpark91]

I think it would be more practical to make a sheet where you would have to input the times yourself and then use formulas.
If you really want a stopwatch function for each car, it would require VBA codes.