How to convert into number?
 

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

How to convert into number?
 

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