Convert degrees to minutes for Google Maps in Excel

Normal Formula

=”N” & INT(H2) & ” ” & ROUND(((H2 – INT(H2)) * 60), 6)

Advanced Excel Formula:

= IF(INT(F41) < 0, “”, “E” & INT(F41) & ” ” & IF((F41 – INT(F41)) * 60 < 10, “0”, “”) &  ROUND(((F41 – INT(F41)) * 60), 6))

If less than zero, show nothing and also adds a 0 if less than 10

Advertisements

One Response to “Convert degrees to minutes for Google Maps in Excel”

  1. Nenu Says:

    Thanks ta xejn ta’


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: