DECIMAL TIME CONVERTER EXCEL TEMPLATE VERIFICATION

I've done This sheet that would be very useful to a friend who some time ago was looking to send to Google Earth some data that were in UTM.

DECIMAL TIME CONVERTER EXCEL TEMPLATE VERIFICATION

I recommend that you familiarize yourself with this form of verification and understanding How the UTM coordinates work To get the most out of the tool in Excel.

In geographical coordinates, this would be Long= -8 ° -5 '-59 ”, lat= 19 ° 24 ' 18 ”, (to display the grid in google Earth, do “view/grid”) (for what you do not know, to see UTM coordinates you only go to tools / options / vista3D / show lat / long) Let's start familiarizing ourselves with this: according to Google Earth, the coordinates of the Palace of Sports in DF would be X = 489513.59, Y = 2,145,667.38 considering that Google Earth uses WGS84 datum. Let's see now this tool that does the same process in reverse, that is, having coordinates in UTM format (Universal Traverso de Mercator) and knowing the area, transform them to latitudes and geographical longitudes. In the previous post we had shown an Excel sheet to convert coordinates Geographic to UTM From a sheet that had popularized Gabriel Ortiz.

Decimal time converter excel template