Excel time format problem

[AussieSteve]

Currently trying to figure out a number format problem in Excel.
I download a CSV file that has times in the workbook that look like this (01:00:83). After I remove the parentheses it has this number 0.4262____ in the cell. Any number format that I try to apply to that cell would result in 1:01:23 a gain of 0.4? The table below is a snippet of the data in the worksheet, Any help in identifying the problem would be a great help.
Thanks Steve.

time		time
(01:19:30)		1:19:30
(01:12:06)		1:12:06
(01:12:14)		1:12:14
(01:00:83)		0.042627315 h:mm:ss
(00:57:85)		0.04056713
(00:57:28)		0:57:28
(01:00:57)		1:00:57
(01:01:86)		0.043356481
(00:58:46)		0:58:46
(01:03:52)		1:03:52
(00:56:78)		0.039791667

<tbody>
</tbody>

 

[AussieSteve]

Hi Rick.
I am far an expert, that's why I will search anywhere on Excel forums for an a solution to a problem, I discovered this website a bit over one year ago and have only just started to use it, and recently purchased Mr Excel VBA videos which I find easy to understand and it has made me more productive over the last six weeks. To answer your question, here are two of the formulas I have tried to implement into my work, this one from jtakw above in this post:

'=SUBSTITUTE(MID(D1,2,LEN(D1)-2),":",".",2)+0 , where I was still getting .40 one hundredths of a second added to the elapsed time. And this one from MS community :

'=TIMEVALUE(MID(SUBSTITUTE(H2,":",".",2),2,8)) formatted as mm:ss.00 , although this formula is hard to convert the result for calculations. I will now try your formula to see if it will give me a total desired result. And in future try to leave a more detailed response as a result.​

<colgroup><col></colgroup><tbody>
</tbody>

​

<colgroup><col></colgroup><tbody>
</tbody>