how to convert a complex number by a simple formula

hey guys, anyone here knows how to make this happen?

i have lots of Degrees Minutes Seconds (DMS) number , data formatted like this : 26 33 51.332 =>( 26 is D -33 is M -51.332 is S)
and i want to convert them to Decimal Degrees (DD)

the fformula is :
398e37ebca57abf399346e0f44f0572f.png
DD= D + M/60 + S/3600
wikipedia link

the website that using this format

I am amature in excel, also i seriously need something to do this
i think excel can do something like this so i ask this question here
Thanks in advance

Try this, assuming that your data start in A1. Copy down.

=SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",":"),"-","")*IF(LEFT(A1)="-",-24,24)

please attach sample file with some examples and desired results

Hi. Glad you got what you needed (and thanks for the Reputation always appreciated). Home/Format/Increase Decimal & set to whatever you need (it looks like.00 with a left-facing arrow pointing to another 0, below it).

You're welcome. Enjoy your Saturday in sunny and (by comparison with here) warm Isfahan...