Manipulating imported times

  • Thread starter Thread starter Xt
  • Start date Start date
X

Xt

Hi folks.

I have copied some athletic times from a website into Excel 2007.
These times look like 03:56.8 on the website and in the body of the
worksheet. I want to convert these times into seconds, in this case
236.8 s. When I go to the formula bar the times are recorded in the
form 12:03:57 a.m. I have tries various things but the decimals of a
second seem to have gone.

Any suggestions appreciated. Thanks.
 
A1 contains 03:56.8

In B1 enter =D1*24*60*60

Format to General or number and see 236.8


Gord Dibben MS Excel MVP
 
A1 contains  03:56.8

In B1 enter   =D1*24*60*60

Format to General or number and see  236.8

Gord Dibben     MS Excel MVP







- Show quoted text -
Click to expand...

Magic. Thanks Gord.
 
Back
Top