I'm looking for a simple formula for converting latitude and longitude references from degrees, minutes and seconds to the decimal figure. I've googled this, and found suggestions on the Microsoft Visual Basic site, but can't get my head around how to get these to work (I thought I'd cracked it but whenever i open the xls file it just says 'VALUE!' in the boxes where the decimal degrees should be).
Any assistance gratefully received, I have an xls sheet full of co-ordinates, so need a way which converts entire columns, rather than individual locations.
That looks to be along the right lines, but my DMS coordinates aren't in the format 45:30:30 but rather 453030 Do you know how I could convert it to 45:30:30 (i.e. just add a colon between each pair of figures)?
I'll be happy to look at the file but I've realised that the MSKB method is doing the opposite to what you want - it is converting from decimal degrees to degrees minutes and seconds.
Converting Degrees, Minutes, And Seconds To Decimal Degrees
While it may be useful to enter degrees, minutes, and seconds in the time format, these values are not useful for computation. To convert DMS values to decimal degrees (e.g., 45:30:30 to 45.50833), multiply the DD:MM:SS value by 24, and format the cell as General. For example, =A1*24
is what you want, taken from my earlier 'click here'.
I think I've got it now, thanks VoG for your assistance. In case you're wondering what this is for, this is the website - Adventure Ecology - click here It's an expedition to the North Pole to encourage awareness about climate change, particularly for schools and educational institutions - click here
This thread is now locked and can not be replied to.