Manipulating imported times
 

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.

Manipulating imported times
 

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

On Fri, 18 Mar 2011 13:09:34 -0700 (PDT), Xt wrote:

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.

Manipulating imported times
 

On Mar 19, 9:39*am, Gord Dibben wrote:
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



On Fri, 18 Mar 2011 13:09:34 -0700 (PDT), Xt wrote:
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.- Hide quoted text -

- Show quoted text -

Magic. Thanks Gord.

Manipulating imported times
 

I see you overcame the typo........D1.........in my post<g

Thanks for the feedback.

Lots of good stuff for working with dates and times at Chip Pearson's site.

Link to his Topic Index will get you started.

http://www.cpearson.com/excel/topic.aspx


Gord


On Fri, 18 Mar 2011 15:13:38 -0700 (PDT), Xt wrote:

On Mar 19, 9:39*am, Gord Dibben wrote:
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



On Fri, 18 Mar 2011 13:09:34 -0700 (PDT), Xt wrote:
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.- Hide quoted text -

- Show quoted text -

Magic. Thanks Gord.