K
kobbie5h
Is there a simple way to convert from angles in degrees, minutes and seconds
to decimal degrees?
eg 45°30'00" = 45.5°
to decimal degrees?
eg 45°30'00" = 45.5°
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
M
Mike
K
kobbie5h
Thanks,
It's so simple I forgot how to do it.
It's so simple I forgot how to do it.
T
timothyl
kobbie5h said:Is there a simple way to convert from angles in degrees, minutes and seconds
to decimal degrees?
eg 45°30'00" = 45.5°
P
Peo Sjoblom
R
Rick Rothstein \(MVP - VB\)
If you are talking about "in another cell", then this formula seems to do
what you want...
=LEFT(A1,FIND(CHAR(176),A1)-1)+24*TIME(0,--MID(A1,LEN(A1)-5,2),--MID(A1,LEN(A1)-2,2))
Rick
what you want...
=LEFT(A1,FIND(CHAR(176),A1)-1)+24*TIME(0,--MID(A1,LEN(A1)-5,2),--MID(A1,LEN(A1)-2,2))
Rick