Trying to paste tabular data into Excel from the web. The web table looks like this.
<tbody>
</tbody>
The first three columns are "elapsed time" not clock time. So the first column is 12 minutes 30 sec, 6 min 10 sec, etc.
Excel represents the first column as:
12:30:00 AM
12:06:10 AM
12:08:50 AM
12:07:40 AM
12:09:40 AM
10:40:00 AM
11:10:00 AM
The first question is "can i get Excel to just represent these as elapsed time, not clock time?"
Secondly there is a problem. Note that the value in the first row, 12:30 is represented as 12:30:00 AM. But, the value in the second row, 6:10.0 is represented as 12:06:10 AM. Why is this? It looks like values pasted in with a decimal after the seconds, get treated as an offset from 12:00:00 while the others are not. It is a very strange behavior. If it were not for that, i could multiply values by 24 and get the elapsed time in minutes. But in this case, 12:30*24 = 12.50 minutes (correct), but 06:10.0*24 = 0.10, not correct.
Thanks for any help with this that you can provide!
1 | 12:30 | 12:30 | 9:14 | 0.74 | 0 | 453 | 3.6 | 4.8 | 22.6 | 96 | 115 | 78.9 | 63 |
2 | 6:10.0 | 18:40 | 3:40 | 0.79 | 0 | 413 | 7.7 | 12.9 | 31.9 | 102 | 135 | 77.0 | 33 |
3 | 8:50.0 | 27:30 | 8:31 | 1.40 | 0 | 2,034 | 9.5 | 9.9 | 12.2 | 87 | 109 | 75.1 | 28 |
4 | 7:40.0 | 35:10 | 5:27 | 1.28 | 0 | 1,165 | 10.0 | 14.1 | 29.1 | 102 | 114 | 73.7 | 38 |
5 | 9:40.0 | 44:50 | 7:48 | 1.09 | 0 | 1,165 | 6.8 | 8.4 | 11.6 | 89 | 109 | 71.8 | 31 |
6 | 10:40 | 55:30 | 8:45 | 1.41 | 0 | 1,158 | 7.9 | 9.6 | 26.7 | 102 | 123 | 71.8 | 54 |
7 | 11:10 | 1:06:40 | 8:47 | 0.71 | 0 | 968 | 3.8 | 4.9 | 14.8 | 92 | 106 | 67.1 | 34 |
<tbody>
</tbody>
The first three columns are "elapsed time" not clock time. So the first column is 12 minutes 30 sec, 6 min 10 sec, etc.
Excel represents the first column as:
12:30:00 AM
12:06:10 AM
12:08:50 AM
12:07:40 AM
12:09:40 AM
10:40:00 AM
11:10:00 AM
The first question is "can i get Excel to just represent these as elapsed time, not clock time?"
Secondly there is a problem. Note that the value in the first row, 12:30 is represented as 12:30:00 AM. But, the value in the second row, 6:10.0 is represented as 12:06:10 AM. Why is this? It looks like values pasted in with a decimal after the seconds, get treated as an offset from 12:00:00 while the others are not. It is a very strange behavior. If it were not for that, i could multiply values by 24 and get the elapsed time in minutes. But in this case, 12:30*24 = 12.50 minutes (correct), but 06:10.0*24 = 0.10, not correct.
Thanks for any help with this that you can provide!