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