Menu

Extracting Numeric Data from a Delimited Text String

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.worksheet.functions

Harlan Grove

Posts: n/a

Default

Extracting Numeric Data from a Delimited Text String

wrote...
Actually, it doesn't quite work that well. Here's the problem

001:02:59:48 2.996666667
000:11:05:46 11.09611111

The first one is wrong. The 001 is the number of days this event
occured, so in this case, the answer should be 26.996666667.
....

Try

=24*(LEFT(x,FIND(":",x)-1)+RIGHT(x,8))

where x is a reference to the cell in question. The result is hours
with fractional hours.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Extrapolate numeric values from text string	Henrik	Excel Worksheet Functions	4	November 3rd 05 06:25 PM
Search/Extract Data w/in Text File	D.Parker	Excel Discussion (Misc queries)	4	June 21st 05 07:33 PM
Formulas dealing with text data	Bagia	Excel Worksheet Functions	6	June 20th 05 10:29 PM
extracting data from a text string of varying length	andy from maine	Excel Discussion (Misc queries)	4	March 28th 05 07:11 PM
Extracting numeric values from string	RJF	Excel Worksheet Functions	3	January 5th 05 10:48 PM

All times are GMT +1. The time now is 04:54 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement