need immediate help

[Kelley492775]

I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is 2.0 off the quickest time. in a 3D format each D is 1.0 second split off the quickest time. Here is an example of the setup of how I manually do it. thanks so much in advanced.

#	RIDER'S NAME	HORSE'S NAME	TIME	PLACE	DIVISION
35	Lacie Brownless	Sister	15.686	1st	1D
11	Carlie Redfern	Peanut	16.092	2nd	1D
7	Julie Shaw	Roxy	16.152	3rd	1D
22	Rainey Booska	Jake	16.157	4th	1D
37	Elana Marchetti	Cashmere	16.417
14	Carlie Cooper	Bug	16.526
1	Pam Alderman	Dunie	16.671
23	Brittany Osburn	Tango	16.676
42	Julie Shaw	Bubba J	16.689	1ST	2D
33	Laurie Boger	Delta Jet	16.742	2nd	2D
2	Meghan Artymowycz	Scarlett	16.785	3rd	2D
32	Donna Lowery	Raisin	16.874	4th	2D
6	Stacy Marchetti	Felicity	16.879
31	Kendall Green	Jetter	17.095
28	Melissa Green	Annie	17.223
12	Carrie Wilmer	Ruger	17.438
36	Taylor Cronk	Katara	17.5
8	Brooke Buffkin	Harley	17.65
45	Denise Vickers	Harley	17.66
29	Kim Redfern	Dash	17.869	1ST	3D
16	Kat McCaslin	Levi	17.943	2nd	3D
21	Brittany Shortt	Bailey	17.959	3rd	3D
3	Caressa Thomas	Rocket	18.002	4th	3D
10	April Bratcher	Boo	18.008
47	Kayla Kiechle	Urban Tiger	18.219
18	Candace Fuller	Moonshine	18.259
48	Brooke Buffkin	CJ	18.263
41	Eve Santiago	My Lady	18.297
5	Taylor Cronk	Toph	18.414
43	Darlene Hawk	Rosa	18.496
9	Sarah Lapinski	Passion	18.956
44	Samantha Williams	Tucker	19.301
50	Kat Citta	Major	19.368
4	Jenny Parrott	Biscuit	19.944
30	Emily Faith Holder	Moxie	20.147
13	Missi Crapps	Martini	20.165
39	Brittany Darford	Mr No Name	21.004
46	Abby Campbell	Bubbles	21.621
25	Sage Stovall	Angel	24.237
24	Slone Fleckinger	Chancey	25.402
15	Alexis Huland	Buster	NT
17	Katie Corona	Power Commnder	NT
19	Jackie Brockhurst	Razz	nt
20	Emily Bevers	Rumor	nt
26	Shelby Gromme	Rusty	nt
27	Pam Alderman	RJ	nt
34	Lexi Woods	Chica	nt
38	Kaelynn Hawk	Luna	nt
40	Michelle Cartwright	Jessie	nt
49	KAMERON Laube	Slammer	nt

<tbody>
</tbody>

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1041730-3d-barrel-racing-spreadsheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.