Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
Posts: 49
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 621
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
Posts: 49
Default 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.
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 621
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help With Manipulating Data Pat Excel Discussion (Misc queries) 3 November 21st 08 02:41 PM
Manipulating Arrays Alan Beban[_2_] Excel Worksheet Functions 0 November 8th 07 09:10 PM
manipulating dates ghostinhawaii Excel Worksheet Functions 2 March 24th 07 06:16 AM
manipulating columns GISDude Charts and Charting in Excel 0 March 1st 06 11:40 PM
Manipulating shapes thePriest Excel Discussion (Misc queries) 0 April 20th 05 06:41 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"