Mar 21 2022 10:50 AM
I want to make a VBA function that will return a value in decimal degrees, using the degree, minutes and seconds values in the three cells to the left of any cell in which I choose enter the function. Essentially. it will perform the calculation
Decimal degrees = degrees + minutes/60 + seconds/ 3600
As for example here:
D | M | S | Decimal degrees |
3 | 33 | 56 | 3.56555556 |
I have made a number of relevant searches, but the answers seem considerably more complicated than I would have expected. Surely there must be a simple VBA method to retrieve the values one, two, and three spaces to the left of the cell in which the function is entered?
Mar 21 2022 11:17 AM
Hi @Gukeli
A1= degree B1=Minutes C1=seconds
you can use a simple formula like this: =A1+(B1/60)+(C1/3600)
or use sum function: =SUM(A1+(B1/60)+(C1/3600))
Mar 21 2022 11:38 AM
Mar 21 2022 11:53 AM
Mar 21 2022 11:58 AM