How to convert into number?

's Computer Specifications

Does anyone have any suggestions on how to convert following code into numbers?
There is a code in cell A1 05SG07.
The format for the code is 2-digit numbers + 2 char + 2-dgit numbers
If the char is SG, then it converts to 270, then 270 + 05 + 07/60 = 275.117
05 comes from the first 2-digit numbers and 07 comes from the last 2-digit
numbers.
275.117 should be returned in cell B1.
Does anyone have any suggestions on how to convert it into number?
Thanks in advance for any suggestions
Eric

's Computer Specifications

Maybe

=270+LEFT(A1,2)+RIGHT(A1,2)/60

Mike

"Eric" wrote:

> Does anyone have any suggestions on how to convert following code into numbers?
> There is a code in cell A1 05SG07.
> The format for the code is 2-digit numbers + 2 char + 2-dgit numbers
> If the char is SG, then it converts to 270, then 270 + 05 + 07/60 = 275.117
> 05 comes from the first 2-digit numbers and 07 comes from the last 2-digit
> numbers.
> 275.117 should be returned in cell B1.
> Does anyone have any suggestions on how to convert it into number?
> Thanks in advance for any suggestions
> Eric
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert number to % using only custom number format challenge	Brotherharry	Microsoft Excel Misc	7	2nd Jun 2009 06:29 PM
Convert a number formatted as text to a number in a macro	MACRE0	Microsoft Excel Programming	2	22nd Oct 2005 02:51 AM
convert text-format number to number in excel 2000%3f	=?Utf-8?B?TGFycnk=?=	Microsoft Excel Misc	1	29th Jul 2005 08:18 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m	=?Utf-8?B?YWdlbmRhOTUzMw==?=	Microsoft Excel Misc	8	20th Jan 2005 10:24 PM
command excel macros to convert a list 5 number number combinati.	=?Utf-8?B?ZXhjYWxpYnVy?=	Microsoft Access Macros	0	7th Dec 2004 04:55 AM