převod souřadnic
můžete mi prosím někdo poradit vzoreček na převod souřadnic
WGS84 délka:
16.5981083 - > 16°35'53.19"
WGS84 šířka:
49.2184865 - > 49°13'6.551"
WGS84 délka:
16.5981083 - > 16°35'53.19"
WGS84 šířka:
49.2184865 - > 49°13'6.551"
trebars v exceli, v najhorsom pripade rucne
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm
presne tohle jsem shanel - diky
[QUOTE="risko"]trebars v exceli, v najhorsom pripade rucne
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm[/QUOTE]
[QUOTE="risko"]trebars v exceli, v najhorsom pripade rucne
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm[/QUOTE]
presne tohle jsem shanel - diky
[QUOTE="risko"]trebars v exceli, v najhorsom pripade rucne
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm[/QUOTE]
[QUOTE="risko"]trebars v exceli, v najhorsom pripade rucne
A1 = 16,45897
B1 = =CONCATENATE(INT(A1);"°";INT((A1-INT(A1))*60);"´";(((A1-INT(A1))*60)-INT((A1-INT(A1))*60))*60;"""")
a mas to
popripade si zaokruhli poslednu polozku na tolko desatinnych miest kolko chces...
16,45987 -> 16°27´35,5319999999952"
popripade nieco z
http://exceltips.vitalnews.com/Pages/T0937_Displaying_Latitude_and_Longitude.html
http://www.cpearson.com/excel/latlong.htm[/QUOTE]