Thread: translate degrees to latitude longitude
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default translate degrees to latitude longitude
If they are entered as an Excel time (ie, nn:nn:nn), multiply by 24 (and
format as a number) to get decimal degrees.

Regards,
Fred.

"Math Teacher" <Math wrote in message
...
Is there an Excel formula or macro to translate locations on the earth in
degrees/minutes/seconds to decimal latitude and longitude degrees?

Reply With QuoteReply With Quote