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

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