KM Formula require

[Ketan_ashiyani]

Dear Team,

We need to City to City KM formula require and we have Latitude & Longitude data is available.

Rajkot to Jamnagar = 90.9 KM show as per google

 

[Sergius]

Hello! I hope this will help.

Book1.xlsm
	F	G	H	I	J	K	L
25	location_1	latitude_1	longitude_1	location_2	latitude_2	longitude_2	distance
26	Rajkot	22,28056	70,88909	Jamnagar	22,49399	70,05388	89,09
Sheet1

Cell Formulas
Range	Formula
L26	L26	=ACOS(SIN(RADIANS(G26))*SIN(RADIANS(J26))+COS(RADIANS(G26))*COS(RADIANS(J26))*COS((RADIANS(K26-H26))))*6371

6371 In the formula - the radius of the Earth