Spreadsheet: 97097d1296303800-excel-2007-conditional-formatting-multiple-sheets-test
Sheet: XC Timing

No | Start Time | Finish Time | Time Taken | Penalties
1 | 11:00:00 | 11:04:10 |  |  |  | Sections A & B
2 | 11:00:00 | 11:04:15
3 | 11:00:00 | 11:10:01 |  |  |  | 2250 | metres - Course distance |  |  | @ | 450 | metres / minute - Optimum Speed
4 | 11:00:00 | 11:05:05
5 |  |  |  |  |  |  |  |  |  | @ | 520 | metres / minute - "Too Fast" Speed
6
7 |  |  |  |  |  |  | mins : secs - Optimum Time
8 |  |  |  |  |  |  |  |  |  |  |  | mins : secs - Penalty free "Too-Fast" Window
9 | 11:00:00 | 11:04:10 |  |  |  |  | mins : secs - "Too Fast" Time
10
11 |  |  |  |  |  | 0.4 | Penalty point for every second slower than the Optimum Time
12
13 |  |  |  |  |  | 1 | Penalty Point for every second faster than the "Too Fast" time
14
15 |  |  |  |  |  | E | Elimination for exceeding the Time Limit (which is twice the optimum time)
16
17
18 |  |  |  |  |  | Use auto-correct to change full stop to colon for entering times:
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67 | 11:00:00 | 11:05:05
68 | 11:00:00 | 11:04:15
69 | 11:00:00 | 11:10:01
70 | 11:00:00 | 11:05:05 |  |  |  | Sections C & D
71 | 11:00:00 | 11:04:15
72 | 11:00:00 | 11:10:01 |  |  |  | 2250 | metres - Course distance |  |  | @ | 450 | metres / minute - Optimum Speed BE90
73
74 |  |  |  |  |  |  |  |  |  | @ | 520 | metres / minute - "Too Fast" Speed
75
76 |  |  |  |  |  |  | mins : secs - Optimum Time
77 |  |  |  |  |  |  |  |  |  |  |  | mins : secs - Penalty free "Too-Fast" Window
78 |  |  |  |  |  |  | mins : secs - "Too Fast" Time
79
80 |  |  |  |  |  | 0.4 | Penalty point for every second slower than the Optimum Time
81
82 |  |  |  |  |  | 1 | Penalty Point for every second faster than the "Too Fast" time
83
84 |  |  |  |  |  | E | Elimination for exceeding the Time Limit (which is twice the optimum time)
85
86
87 |  |  |  |  |  | Use auto-correct to change full stop to colon for entering times:
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136 | 11:00:00 | 11:05:05
137 | 11:00:00 | 11:04:15
138 | 11:00:00 | 11:10:01
140 | 11:00:00 | 11:05:05
141 | 11:00:00 | 11:04:15
142 | 11:00:00 | 11:10:01 |  |  |  | 2250 | metres - Course distance |  |  | @ | 450 | metres / minute - Optimum Speed BE90
143
144 |  |  |  |  |  |  |  |  |  | @ | 520 | metres / minute - "Too Fast" Speed
145
146 |  |  |  |  |  |  | mins : secs - Optimum Time
147 |  |  |  |  |  |  |  |  |  |  |  | mins : secs - Penalty free "Too-Fast" Window
148 |  |  |  |  |  |  | mins : secs - "Too Fast" Time
149
150 |  |  |  |  |  | 0.4 | Penalty point for every second slower than the Optimum Time
151
152 |  |  |  |  |  | 1 | Penalty Point for every second faster than the "Too Fast" time
153
154 |  |  |  |  |  | E | Elimination for exceeding the Time Limit (which is twice the optimum time)
155
156
157 |  |  |  |  |  | Use auto-correct to change full stop to colon for entering times:
158
159
160
161
162
163
164
165
166
167
168 | 11:00:00 | 11:05:05
169 | 11:00:00 | 11:04:15
170 | 11:00:00 | 11:10:01