Hi Folks,
New to the site ...thanks so much for all the contributions.
I have a (race/lap) spreadsheet that has the following (Note: square brackets [text] are to isolate examples and not in the actual formulas) :
- Sheet 1 (Registration): Manually entered race number (Plate #; Column B), racer info (name, etc) and Number of Laps pulled from "Laps" sheet [=SUMIF(Laps!B7:B500,'Registration List'!B6,Laps!C7:C500)] and Total Race time pulled from race sheet [{=MAX(IF(Laps!B7:B500='Registration List'!B6,Laps!E7:E500))}]
- Sheet 2 (Laps): Enter initial value (0) in "B7" to start race time [=IF(B7<>"",IF(D7="",NOW(),D7),"")]; and manually enter Racer "Plate #" (Column B) each time racer crosses the line; formula collects the "lap" [=IF(B8<>"",IF(D8="",NOW(),D8),"")] and associated times [=IF(B7<>"",IF(D7="",NOW(),D7),"")] and elapsed race time [=IF(D8<>"",D8-$D$7,"")]
- Total laps are "counted" and displayed next to racer's info and racer's last (MAX) time is pulled into the "Registration" sheet to show racer's Total race time (see above)
Ideally, I would like to pull the individual lap times for each racer as well, but this is where I start to get lost ...
Plate # may occur multiple times in Column B w' associated lap times ... I'd like to isolate the Plate #s (e.g., 41) and pull out the elapsed time for EACH lap. More specifically:
Start time: 12:00
Plate #41:
Lap 1 (12:30:00) ... 00:30:00
Lap 2 (13:01:02) ... 00:31:02
Lap 3 (13:33:05) ... 00:32:03
... etc for each racer
Hope I provided enough information ... looking forward to your thoughts. Thanks in advance.
Bookmarks