Hello,

Please help me out, I cant find a procedure to accomplish this convertion.

So I have time in a MINUTES/SECONDS/1/1000 of a second.

For example:

1:22:223
1:22:958
1:21:650
1:21:999
1:23:536

And I want to convert this into:

82,223
82,958
81,650
81,999
83,536

I have tried to accomplish this with these steps:

1. Text into columns
2. Replace . with ,
2. Concentrate function.

But it doesnt work.


Any help ?

Thx