Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Text to columns. arrgh!
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Text to columns. arrgh!
Text to columns. arrgh!
17-05-2008 1:25 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I am using Excel to analyse my BT bill. In it is a column for duration of call in format hh:mm:SS
I want to separate the elements in to separate columns so I may recalculate the minutes in decimal. However when I try, all I get in each column are 0s, so that 1:25:23 becomes
00:00:00
What may I be doing wrong, and secondly how should I go about my task, or is there a better way to recalculate the BT data as minutes and parts of minutes in decimal form?
I want to separate the elements in to separate columns so I may recalculate the minutes in decimal. However when I try, all I get in each column are 0s, so that 1:25:23 becomes
00:00:00
What may I be doing wrong, and secondly how should I go about my task, or is there a better way to recalculate the BT data as minutes and parts of minutes in decimal form?
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
4 REPLIES 4
Re: Text to columns. arrgh!
17-05-2008 1:53 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
The way I would do it is just do a text to columns on the duration column. Do it as fixed width and separate at each colon. On the next screen you can choose to not import the colon columns then you should have each number in a separate field.
EG
00:05:37 becomes: 0 5 37
Jeff
EG
00:05:37 becomes: 0 5 37
Jeff
Re: Text to columns. arrgh!
17-05-2008 1:59 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Another way is to use the functions HOUR() MINUTE() and SECOND() functions on the time cell.
Jeff
Jeff
Re: Text to columns. arrgh!
17-05-2008 7:44 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
Re: Text to columns. arrgh!
17-05-2008 11:59 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
The column needs selecting and the format setting for time as well
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Text to columns. arrgh!