Spreadsheet: 49035d1248297924-time-formatting-testspreadsheet2-
Sheet: test

 | Date | Time | 100 ms | Level | Temperature
1 | 2009-07-22 00:00:00 | 13:15:02 | 0 | 2.4772 | 24.864 |  |  | 0
2 | 2009-07-22 00:00:00 | 13:15:02 | 5 | 2.4774 | 24.879 |  |  | 0.5
3 | 2009-07-22 00:00:00 | 13:15:03 | 0 | 2.4784 | 24.888 |  |  | 1
4 | 2009-07-22 00:00:00 | 13:15:03 | 5 | 2.4808 | 24.894 |  |  | 1.5
5 | 2009-07-22 00:00:00 | 13:15:04 | 0 | 2.4812 | 24.897 |  |  | 2
6 | 2009-07-22 00:00:00 | 13:15:04 | 5 | 2.4819 | 24.903 |  |  | 2.5
7 | 2009-07-22 00:00:00 | 13:15:05 | 0 | 2.4822 | 24.904 |  |  | 3
8 | 2009-07-22 00:00:00 | 13:15:05 | 5 | 2.4836 | 24.909 |  |  | 3.5
9 | 2009-07-22 00:00:00 | 13:15:06 | 0 | 2.4831 | 24.909 |  |  | 4
10 | 2009-07-22 00:00:00 | 13:15:06 | 5 | 2.4843 | 24.911 |  |  | 4.5
11 | 2009-07-22 00:00:00 | 13:15:07 | 0 | 2.4847 | 24.913 |  |  | 5
12 | 2009-07-22 00:00:00 | 13:15:07 | 5 | 2.4848 | 24.915 |  |  | 5.5
13 | 2009-07-22 00:00:00 | 13:15:08 | 0 | 2.4849 | 24.917 |  |  | 6
14 | 2009-07-22 00:00:00 | 13:15:08 | 5 | 2.4847 | 24.917 |  |  | 6.5
15 | 2009-07-22 00:00:00 | 13:15:09 | 0 | 2.4857 | 24.919 |  |  | 7
16 | 2009-07-22 00:00:00 | 13:15:09 | 5 | 2.4859 | 24.919 |  |  | 7.5
17 | 2009-07-22 00:00:00 | 13:15:10 | 0 | 2.4866 | 24.92 |  |  | 8
18 | 2009-07-22 00:00:00 | 13:15:10 | 5 | 2.486 | 24.921 |  |  | 8.5
19 | 2009-07-22 00:00:00 | 13:15:11 | 0 | 2.4869 | 24.922 |  |  | 9
20 | 2009-07-22 00:00:00 | 13:15:11 | 5 | 2.4877 | 24.923 |  |  | 9.5
21 | 2009-07-22 00:00:00 | 13:15:12 | 0 | 2.4875 | 24.923 |  |  | 10
22 | 2009-07-22 00:00:00 | 13:15:12 | 5 | 2.4865 | 24.923 |  |  | 10.5
23 | 2009-07-22 00:00:00 | 13:15:13 | 0 | 2.4877 | 24.924 |  |  | 11
24 | 2009-07-22 00:00:00 | 13:15:13 | 5 | 2.4878 | 24.924 |  |  | 11.5
25 | 2009-07-22 00:00:00 | 13:15:14 | 0 | 2.488 | 24.924 |  |  | 12
26 | 2009-07-22 00:00:00 | 13:15:14 | 5 | 2.4885 | 24.925 |  |  | 12.5
27 | 2009-07-22 00:00:00 | 13:15:15 | 0 | 2.4888 | 24.925 |  |  | 13
28 | 2009-07-22 00:00:00 | 13:15:15 | 5 | 2.4891 | 24.925 |  |  | 13.5
29 | 2009-07-22 00:00:00 | 13:15:16 | 0 | 2.4902 | 24.925 |  |  | 14
30 | 2009-07-22 00:00:00 | 13:15:16 | 5 | 2.4897 | 24.926 |  |  | 14.5
31 | 2009-07-22 00:00:00 | 13:15:17 | 0 | 2.49 | 24.925 |  |  | 15
32 | 2009-07-22 00:00:00 | 13:15:18 | 0 | 2.4892 | 24.913 |  |  | 16
33 | 2009-07-22 00:00:00 | 13:15:19 | 0 | 2.4897 | 24.904 |  |  | 17
34 | 2009-07-22 00:00:00 | 13:15:20 | 0 | 2.489 | 24.901 |  |  | 18
35 | 2009-07-22 00:00:00 | 13:15:21 | 0 | 2.4905 | 24.897 |  |  | 19
36 | 2009-07-22 00:00:00 | 13:15:22 | 0 | 2.4897 | 24.893 |  |  | 20
37 | 2009-07-22 00:00:00 | 13:15:23 | 0 | 2.4905 | 24.891 |  |  | 21
38 | 2009-07-22 00:00:00 | 13:15:24 | 0 | 2.4899 | 24.889 |  |  | 22
39 | 2009-07-22 00:00:00 | 13:15:25 | 0 | 2.491 | 24.887 |  |  | 23
40 | 2009-07-22 00:00:00 | 13:15:26 | 0 | 2.4915 | 24.885 |  |  | 24
41 | 2009-07-22 00:00:00 | 13:15:27 | 0 | 2.4918 | 24.883 |  |  | 25
42 | 2009-07-22 00:00:00 | 13:15:28 | 0 | 2.4918 | 24.882 |  |  | 26
43 | 2009-07-22 00:00:00 | 13:15:29 | 0 | 2.4915 | 24.879 |  |  | 27
44 | 2009-07-22 00:00:00 | 13:15:30 | 0 | 2.4914 | 24.877 |  |  | 28
45 | 2009-07-22 00:00:00 | 13:15:31 | 0 | 2.4921 | 24.876 |  |  | 29
46 | 2009-07-22 00:00:00 | 13:15:32 | 0 | 2.4925 | 24.875 |  |  | 30
47 | 2009-07-22 00:00:00 | 13:15:35 | 0 | 2.4915 | 24.855 |  |  | 33
48 | 2009-07-22 00:00:00 | 13:15:38 | 0 | 2.4939 | 24.846 |  |  | 36
49 | 2009-07-22 00:00:00 | 13:15:41 | 0 | 2.493 | 24.838 |  |  | 39
50 | 2009-07-22 00:00:00 | 13:15:44 | 0 | 2.4933 | 24.831 |  |  | 42
51 | 2009-07-22 00:00:00 | 13:15:47 | 0 | 2.4955 | 24.825
52 | 2009-07-22 00:00:00 | 13:15:50 | 0 | 2.4963 | 24.82
53 | 2009-07-22 00:00:00 | 13:15:53 | 0 | 2.4978 | 24.814
54 | 2009-07-22 00:00:00 | 13:15:56 | 0 | 2.4979 | 24.81
55 | 2009-07-22 00:00:00 | 13:15:59 | 0 | 2.4993 | 24.805
56 | 2009-07-22 00:00:00 | 13:16:02 | 0 | 2.4992 | 24.8
57 | 2009-07-22 00:00:00 | 13:16:07 | 0 | 2.5013 | 24.79
58 | 2009-07-22 00:00:00 | 13:16:12 | 0 | 2.5022 | 24.781
59 | 2009-07-22 00:00:00 | 13:16:17 | 0 | 2.5033 | 24.774
60 | 2009-07-22 00:00:00 | 13:16:22 | 0 | 2.5049 | 24.767
61 | 2009-07-22 00:00:00 | 13:16:27 | 0 | 2.5075 | 24.761
62 | 2009-07-22 00:00:00 | 13:16:32 | 0 | 2.5082 | 24.755
63 | 2009-07-22 00:00:00 | 13:16:37 | 0 | 2.5101 | 24.749
64 | 2009-07-22 00:00:00 | 13:16:42 | 0 | 2.5114 | 24.743
65 | 2009-07-22 00:00:00 | 13:16:47 | 0 | 2.5132 | 24.738
66 | 2009-07-22 00:00:00 | 13:16:52 | 0 | 2.5154 | 24.734
67 | 2009-07-22 00:00:00 | 13:16:57 | 0 | 2.5168 | 24.729
68 | 2009-07-22 00:00:00 | 13:17:02 | 0 | 2.5183 | 24.724
69 | 2009-07-22 00:00:00 | 13:17:12 | 0 | 2.5206 | 24.712
70 | 2009-07-22 00:00:00 | 13:17:22 | 0 | 2.5242 | 24.703
71 | 2009-07-22 00:00:00 | 13:17:32 | 0 | 2.5272 | 24.695
72 | 2009-07-22 00:00:00 | 13:17:42 | 0 | 2.5303 | 24.687
73 | 2009-07-22 00:00:00 | 13:17:52 | 0 | 2.5339 | 24.679
74 | 2009-07-22 00:00:00 | 13:18:02 | 0 | 2.5371 | 24.674
75 | 2009-07-22 00:00:00 | 13:18:12 | 0 | 2.5402 | 24.667
76 | 2009-07-22 00:00:00 | 13:18:22 | 0 | 2.5426 | 24.662
77 | 2009-07-22 00:00:00 | 13:18:32 | 0 | 2.5465 | 24.656
78 | 2009-07-22 00:00:00 | 13:18:42 | 0 | 2.5499 | 24.652
79 | 2009-07-22 00:00:00 | 13:18:52 | 0 | 2.5534 | 24.646
80 | 2009-07-22 00:00:00 | 13:19:02 | 0 | 2.557 | 24.641
81 | 2009-07-22 00:00:00 | 13:19:12 | 0 | 2.5605 | 24.638
82 | 2009-07-22 00:00:00 | 13:19:22 | 0 | 2.5641 | 24.633
83 | 2009-07-22 00:00:00 | 13:19:32 | 0 | 2.5661 | 24.629
84 | 2009-07-22 00:00:00 | 13:19:42 | 0 | 2.5707 | 24.626
85 | 2009-07-22 00:00:00 | 13:19:52 | 0 | 2.5739 | 24.622
86 | 2009-07-22 00:00:00 | 13:20:02 | 0 | 2.5762 | 24.618
87 | 2009-07-22 00:00:00 | 13:20:22 | 0 | 2.5831 | 24.611
88 | 2009-07-22 00:00:00 | 13:20:42 | 0 | 2.5888 | 24.603
89 | 2009-07-22 00:00:00 | 13:21:02 | 0 | 2.5955 | 24.598
90 | 2009-07-22 00:00:00 | 13:21:22 | 0 | 2.6011 | 24.592
91 | 2009-07-22 00:00:00 | 13:21:42 | 0 | 2.6085 | 24.587
92 | 2009-07-22 00:00:00 | 13:22:02 | 0 | 2.6161 | 24.583
93 | 2009-07-22 00:00:00 | 13:22:22 | 0 | 2.6225 | 24.58
94 | 2009-07-22 00:00:00 | 13:22:42 | 0 | 2.6274 | 24.575
95 | 2009-07-22 00:00:00 | 13:23:02 | 0 | 2.6354 | 24.571
96 | 2009-07-22 00:00:00 | 13:23:22 | 0 | 2.6415 | 24.569
97 | 2009-07-22 00:00:00 | 13:23:42 | 0 | 2.6481 | 24.564
98 | 2009-07-22 00:00:00 | 13:24:02 | 0 | 2.6548 | 24.561
99 | 2009-07-22 00:00:00 | 13:24:22 | 0 | 2.6612 | 24.559
100 | 2009-07-22 00:00:00 | 13:24:42 | 0 | 2.6668 | 24.555
101 | 2009-07-22 00:00:00 | 13:25:02 | 0 | 2.6735 | 24.553
102 | 2009-07-22 00:00:00 | 13:25:32 | 0 | 2.6826 | 24.549
103 | 2009-07-22 00:00:00 | 13:26:02 | 0 | 2.6916 | 24.547
104 | 2009-07-22 00:00:00 | 13:26:32 | 0 | 2.7012 | 24.543
105 | 2009-07-22 00:00:00 | 13:27:02 | 0 | 2.7117 | 24.542
106 | 2009-07-22 00:00:00 | 13:27:32 | 0 | 2.7203 | 24.54
107 | 2009-07-22 00:00:00 | 13:28:02 | 0 | 2.7308 | 24.538
108 | 2009-07-22 00:00:00 | 13:28:32 | 0 | 2.7398 | 24.537
109 | 2009-07-22 00:00:00 | 13:29:02 | 0 | 2.7493 | 24.536
110 | 2009-07-22 00:00:00 | 13:29:32 | 0 | 2.7598 | 24.535
111 | 2009-07-22 00:00:00 | 13:30:02 | 0 | 2.7697 | 24.535
112 | 2009-07-22 00:00:00 | 13:30:32 | 0 | 2.7792 | 24.534
113 | 2009-07-22 00:00:00 | 13:31:02 | 0 | 2.7885 | 24.533
114 | 2009-07-22 00:00:00 | 13:31:32 | 0 | 2.7977 | 24.532
115 | 2009-07-22 00:00:00 | 13:32:02 | 0 | 2.8071 | 24.531
116 | 2009-07-22 00:00:00 | 13:32:32 | 0 | 2.8176 | 24.53
117 | 2009-07-22 00:00:00 | 13:33:02 | 0 | 2.8267 | 24.53
118 | 2009-07-22 00:00:00 | 13:33:32 | 0 | 2.8366 | 24.53
119 | 2009-07-22 00:00:00 | 13:34:02 | 0 | 2.8474 | 24.529
120 | 2009-07-22 00:00:00 | 13:34:32 | 0 | 2.8555 | 24.528
121 | 2009-07-22 00:00:00 | 13:35:02 | 0 | 2.8653 | 24.528
122 | 2009-07-22 00:00:00 | 13:35:32 | 0 | 2.8747 | 24.529
123 | 2009-07-22 00:00:00 | 13:36:02 | 0 | 2.8833 | 24.528
124 | 2009-07-22 00:00:00 | 13:36:32 | 0 | 2.8948 | 24.529
125 | 2009-07-22 00:00:00 | 13:37:02 | 0 | 2.9034 | 24.53
126 | 2009-07-22 00:00:00 | 13:37:32 | 0 | 2.9127 | 24.53
127 | 2009-07-22 00:00:00 | 13:38:02 | 0 | 2.9218 | 24.53
128 | 2009-07-22 00:00:00 | 13:38:32 | 0 | 2.9311 | 24.531
129 | 2009-07-22 00:00:00 | 13:39:02 | 0 | 2.9395 | 24.531
130 | 2009-07-22 00:00:00 | 13:39:32 | 0 | 2.9496 | 24.531
131 | 2009-07-22 00:00:00 | 13:40:02 | 0 | 2.9599 | 24.531
132 | 2009-07-22 00:00:00 | 13:40:32 | 0 | 2.9685 | 24.53
133 | 2009-07-22 00:00:00 | 13:41:02 | 0 | 2.9783 | 24.53
134 | 2009-07-22 00:00:00 | 13:41:32 | 0 | 2.984 | 24.53
135 | 2009-07-22 00:00:00 | 13:42:02 | 0 | 2.9841 | 24.528
136 | 2009-07-22 00:00:00 | 13:42:32 | 0 | 2.9847 | 24.525
137 | 2009-07-22 00:00:00 | 13:43:02 | 0 | 2.9854 | 24.518
138 | 2009-07-22 00:00:00 | 13:43:32 | 0 | 2.9871 | 24.507
139 | 2009-07-22 00:00:00 | 13:44:02 | 0 | 2.9867 | 24.495
140 | 2009-07-22 00:00:00 | 13:44:32 | 0 | 2.9858 | 24.482
141 | 2009-07-22 00:00:00 | 13:45:02 | 0 | 2.9854 | 24.469