Junior one's mathematical degree minute second conversion method, help! More detailed

Junior one's mathematical degree minute second conversion method, help! More detailed

Conversion of degrees, minutes and seconds
1 degree = 60 minutes
1 minute = 60 seconds
1 degree = 60 minutes = 3600 seconds

In Excel, convert degrees, minutes and seconds to decimals
For example, 121 ° 49.4 & acute; converted to decimal is 121.823333
How to change

If the data is in cell A1, then enter the following formula in another cell to calculate it: = mid (a1,1, find ("°", A1) - 1) + mid (A1, find ("°", A1) + 1, len (A1) - find ("°", A1) - 1) / 60. Note that there is a space between "°" and "4" in your "121 ° 49.4 & # 180;"

How to convert degrees, minutes and seconds into degrees in Excel

Suppose the value is A1,
=LEFT(A1,FIND("°",A1)-1)*1+MID(A1,FIND("°",A1)+1,2)/60+MID(A1,FIND("′",A1)+1,LEN(A1)-FIND("′",A1)-1)/3600
The idea is to extract degree + extract minutes / 60, convert to degree + extract seconds, and convert seconds / 3600 to degree

What is 150.15 △ 1.5?

1010