Spreadsheet: 197452d1354367303-timevalue-function-not-recognizing-1000ths-timer-score-sheets
Sheet: Day 1

Time Keeper's Scoresheet - Day 1
Date: | 2013-01-01 00:00:00
Race Name: | The Great White Crazy Race
 |  |  | Interval | START TIME | DAY 1 FINISH TIME
Day 1 Post | Bib | Musher's Name | (Mins) | Clock Time | Hrs | Mins | Secs | 100ths | DNF/DNS | Clock Time | Day 1 Run Time | #
DNF | 40 | [NAME] | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | DNF | 1900-01-01 00:00:00 | DNF | 100
16 | 41 | [NAME] | 2 | 00:02:00 | 1 | 13 | 56 | 42 |  | 01:13:56 | 01:11:56 | 16
23 | 42 | [NAME] | 4 | 00:04:00 | 1 | 18 | 39 | 88 |  | 01:18:40 | 01:14:40 | 23
12 | 43 | [NAME] | 6 | 00:06:00 | 1 | 14 | 25 | 69 |  | 01:14:26 | 01:08:26 | 12
10 | 44 | [NAME] | 8 | 00:08:00 | 1 | 16 | 11 | 45 |  | 01:16:11 | 01:08:11 | 10
25 | 45 | [NAME] | 10 | 00:10:00 | 1 | 25 | 56 | 22 |  | 01:25:56 | 01:15:56 | 28
25 | 46 | [NAME] | 12 | 00:12:00 | 1 | 27 | 56 | 22 |  | 01:27:56 | 01:15:56 | 27
1 | 47 | Buster | 14 | 00:14:00 | 0 | 45 | 16 | 99 |  | 00:45:17 | 00:31:17 | 1
2 | 48 | [NAME] | 16 | 00:16:00 | 0 | 59 | 59 | 99 |  | 01:00:00 | 00:44:00 | 2
24 | 49 | [NAME] | 18 | 00:18:00 | 1 | 33 | 45 | 22 |  | 01:33:45 | 01:15:45 | 24
DNS | 50 | [NAME] | 20 | 00:20:00 | 0 | 0 | 0 | 0 | DNS | 1900-01-01 00:00:00 | DNS | 99
DNF | 51 | Vivian | 22 | 00:22:00 | 0 | 0 | 0 | 0 | DNF | 1900-01-01 00:00:00 | DNF | 98
39 | 52 | Percival | 24 | 00:24:00 | 3 | 29 | 18 | 66 |  | 03:29:19 | 03:05:19 | 39
37 | 53 | [NAME] | 26 | 00:26:00 | 1 | 55 | 32 | 47 |  | 01:55:32 | 01:29:32 | 37
38 | 54 | [NAME] | 28 | 00:28:00 | 1 | 59 | 59 | 99 |  | 02:00:00 | 01:32:00 | 38
32 | 55 | [NAME] | 30 | 00:30:00 | 1 | 48 | 53 | 33 |  | 01:48:53 | 01:18:53 | 32
21 | 56 | Helmut | 32 | 00:32:00 | 1 | 45 | 55 | 62 |  | 01:45:56 | 01:13:56 | 21
33 | 57 | Regis | 34 | 00:34:00 | 1 | 53 | 22 | 81 |  | 01:53:23 | 01:19:23 | 33
19 | 58 | Kelly | 36 | 00:36:00 | 1 | 49 | 36 | 83 |  | 01:49:37 | 01:13:37 | 19
36 | 59 | Billy | 38 | 00:38:00 | 2 | 1 | 52 | 37 |  | 02:01:52 | 01:23:52 | 36
35 | 60 | [NAME] | 40 | 00:40:00 | 2 | 1 | 32 | 81 |  | 02:01:33 | 01:21:33 | 35
18 | 61 | [NAME] | 42 | 00:42:00 | 1 | 54 | 36 | 21 |  | 01:54:36 | 01:12:36 | 18
20 | 62 | Jasper | 44 | 00:44:00 | 1 | 57 | 45 | 93 |  | 01:57:46 | 01:13:46 | 20
29 | 63 | [NAME] | 46 | 00:46:00 | 2 | 2 | 43 | 28 |  | 02:02:43 | 01:16:43 | 29
DNS | 64 | [NAME] | 48 | 00:48:00 | 0 | 0 | 0 | 0 | DNS | 1900-01-01 00:00:00 | DNS | 97
14 | 65 | [NAME] | 50 | 00:50:00 | 1 | 59 | 32 | 88 |  | 01:59:33 | 01:09:33 | 14
13 | 66 | [NAME] | 52 | 00:52:00 | 2 | 0 | 42 | 25 |  | 02:00:42 | 01:08:42 | 13
9 | 67 | Olly | 54 | 00:54:00 | 2 | 1 | 5 | 13 |  | 02:01:05 | 01:07:05 | 9
8 | 68 | [NAME] | 56 | 00:56:00 | 2 | 2 | 47 | 18 |  | 02:02:47 | 01:06:47 | 8
30 | 69 | Curtis | 58 | 00:58:00 | 2 | 15 | 35 | 28 |  | 02:15:35 | 01:17:35 | 30
17 | 70 | Nathan | 60 | 01:00:00 | 2 | 11 | 57 | 99 |  | 02:11:58 | 01:11:58 | 17
25 | 71 | Lester | 62 | 01:02:00 | 2 | 17 | 56 | 22 |  | 02:17:56 | 01:15:56 | 26
7 | 72 | [NAME] | 64 | 01:04:00 | 2 | 10 | 31 | 88 |  | 02:10:32 | 01:06:32 | 7
11 | 73 | Juniper | 66 | 01:06:00 | 2 | 14 | 21 | 55 |  | 02:14:22 | 01:08:22 | 11
5 | 74 | Vlad | 68 | 01:08:00 | 2 | 12 | 55 | 20 |  | 02:12:55 | 01:04:55 | 5
25 | 75 | Brent | 70 | 01:10:00 | 2 | 25 | 56 | 22 |  | 02:25:56 | 01:15:56 | 25
34 | 76 | Ronny | 72 | 01:12:00 | 2 | 33 | 10 | 13 |  | 02:33:10 | 01:21:10 | 34
4 | 77 | [NAME] | 74 | 01:14:00 | 2 | 18 | 25 | 02 |  | 02:18:25 | 01:04:25 | 4
6 | 78 | Mark | 76 | 01:16:00 | 2 | 21 | 46 | 5 |  | 02:21:46 | 01:05:46 | 6
31 | 79 | [NAME] | 78 | 01:18:00 | 2 | 35 | 59 | 12 |  | 02:35:59 | 01:17:59 | 31
15 | 80 | Adela | 80 | 01:20:00 | 2 | 30 | 7 | 27 |  | 02:30:07 | 01:10:07 | 15
DNF | 81 | [NAME] | 82 | 01:22:00 | 0 | 0 | 0 | 0 | DNF | 1900-01-01 00:00:00 | DNF | 96
22 | 82 | [NAME] | 84 | 01:24:00 | 2 | 38 | 25 | 77 |  | 02:38:26 | 01:14:26 | 22
3 | 83 | [NAME] | 86 | 01:26:00 | 2 | 25 | 22 | 21 |  | 02:25:22 | 00:59:22 | 3
* | 84 |  | 88 | 01:28:00 |  |  |  |  |  | * | *
* | 85 |  | 90 | 01:30:00 |  |  |  |  |  | * | *
* | 86 |  | 92 | 01:32:00 |  |  |  |  |  | * | *
* | 87 |  | 94 | 01:34:00 |  |  |  |  |  | * | *
* | 88 |  | 96 | 01:36:00 |  |  |  |  |  | * | *
* | 89 |  | 98 | 01:38:00 |  |  |  |  |  | * | *
* | 90 |  | 100 | 01:40:00 |  |  |  |  |  | * | *
* | 91 |  | 102 | 01:42:00 |  |  |  |  |  | * | *
* | 92 |  | 104 | 01:44:00 |  |  |  |  |  | * | *
* | 93 |  | 106 | 01:46:00 |  |  |  |  |  | * | *
* | 94 |  | 108 | 01:48:00 |  |  |  |  |  | * | *
* | 95 |  | 110 | 01:50:00 |  |  |  |  |  | * | *
* | 96 |  | 112 | 01:52:00 |  |  |  |  |  | * | *
* | 97 |  | 114 | 01:54:00 |  |  |  |  |  | * | *
* | 98 |  | 116 | 01:56:00 |  |  |  |  |  | * | *
* | 99 |  | 118 | 01:58:00 |  |  |  |  |  | * | *
* | 100 |  | 120 | 02:00:00 |  |  |  |  |  | * | *
* | 101 |  | 122 | 02:02:00 |  |  |  |  |  | * | *
* | 102 |  | 124 | 02:04:00 |  |  |  |  |  | * | *
* | 103 |  | 126 | 02:06:00 |  |  |  |  |  | * | *
* | 104 |  | 128 | 02:08:00 |  |  |  |  |  | * | *
* | 105 |  | 130 | 02:10:00 |  |  |  |  |  | * | *
* | 106 |  | 132 | 02:12:00 |  |  |  |  |  | * | *
* | 107 |  | 134 | 02:14:00 |  |  |  |  |  | * | *
* | 108 |  | 136 | 02:16:00 |  |  |  |  |  | * | *
* | 109 |  | 138 | 02:18:00 |  |  |  |  |  | * | *
* | 110 |  | 140 | 02:20:00 |  |  |  |  |  | * | *
* | 111 |  | 142 | 02:22:00 |  |  |  |  |  | * | *
* | 112 |  | 144 | 02:24:00 |  |  |  |  |  | * | *
* | 113 |  | 146 | 02:26:00 |  |  |  |  |  | * | *
* | 114 |  | 148 | 02:28:00 |  |  |  |  |  | * | *
* | 115 |  | 150 | 02:30:00 |  |  |  |  |  | * | *
* | 116 |  | 152 | 02:32:00 |  |  |  |  |  | * | *
* | 117 |  | 154 | 02:34:00 |  |  |  |  |  | * | *
* | 118 |  | 156 | 02:36:00 |  |  |  |  |  | * | *
* | 119 |  | 158 | 02:38:00 |  |  |  |  |  | * | *
* | 120 |  | 160 | 02:40:00 |  |  |  |  |  | * | *
* | 121 |  | 162 | 02:42:00 |  |  |  |  |  | * | *
* | 122 |  | 164 | 02:44:00 |  |  |  |  |  | * | *
* | 123 |  | 166 | 02:46:00 |  |  |  |  |  | * | *
* | 124 |  | 168 | 02:48:00 |  |  |  |  |  | * | *
* | 125 |  | 170 | 02:50:00 |  |  |  |  |  | * | *
* | 126 |  | 172 | 02:52:00 |  |  |  |  |  | * | *
* | 127 |  | 174 | 02:54:00 |  |  |  |  |  | * | *
* | 128 |  | 176 | 02:56:00 |  |  |  |  |  | * | *
* | 129 |  | 178 | 02:58:00 |  |  |  |  |  | * | *
* | 130 |  | 180 | 03:00:00 |  |  |  |  |  | * | *
* | 131 |  | 182 | 03:02:00 |  |  |  |  |  | * | *
* | 132 |  | 184 | 03:04:00 |  |  |  |  |  | * | *
* | 133 |  | 186 | 03:06:00 |  |  |  |  |  | * | *
* | 134 |  | 188 | 03:08:00 |  |  |  |  |  | * | *
* | 135 |  | 190 | 03:10:00 |  |  |  |  |  | * | *
* | 136 |  | 192 | 03:12:00 |  |  |  |  |  | * | *
* | 137 |  | 194 | 03:14:00 |  |  |  |  |  | * | *
* | 138 |  | 196 | 03:16:00 |  |  |  |  |  | * | *
* | 139 |  | 198 | 03:18:00 |  |  |  |  |  | * | *