Convert Deg To Decimal

[Excel777]

Hi,

i want formula to convert this type of Deg Min Sec Into Decimal

0°08'46"

1°39'46"

3°05'57"

4°26'45"

5°41'37"

6°50'02"

7°51'29"

8°45'34"

9°31'53"

10°10'06"

10°40'00"

11°01'26"

11°14'19"

11°18'42"

11°14'46"

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

thanks for your help

 

[Rick Rothstein]

I think this formula will work...

=LEFT(A1,LEN(A1)-7)+24*("0:"&SUBSTITUTE(MID(A1,LEN(A1)-5,5),"'",":"))

 

[Excel777]

Million Of Thanks Mr Rick Rothstein Works Great Many thanks For Your Help