G
Guest
I have data in the format eg 179.95 I need to convert this from the decimal format into degrees, minutes and seconds
I can do this manually (0.95/100)*60 gives me the minutes value of 0.57 answer is 179 degrees 57 minutes 0 seconds
Any help with a formula would be much appreciate
Thx in advance
I can do this manually (0.95/100)*60 gives me the minutes value of 0.57 answer is 179 degrees 57 minutes 0 seconds
Any help with a formula would be much appreciate
Thx in advance