Time to number

[thiver]

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

[DonkeyOte]

Please post a sample file with sample values
(this will also account for regional differences in syntax)

[thiver]

Hello,

Sample file is attached.

Best regards

[DonkeyOte]

Multiply the values by 86400, eg

B1: =A1*86400
Format to General / Number