excel常用函数

--excel转时间格式
=TEXT((LEFT(B2,10)+8*3600)/86400+70*365+19,"yyyy-MM-DD HH:mm:ss")

--excel计算经纬度球面距离(x：经度,y:纬度)

=ROUND(2*ASIN(SQRT(POWER(SIN((Y2*PI()/180-Y1*PI()/180)/2),2)+COS(Y2*PI()/180)*COS(Y1*PI()/180)*POWER(SIN((X2*PI()/180-X1*PI()/180)/2),2)))*6378137*10000,2)/10000