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

Hello, nice to meet you

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

1 Comments

Leave a Reply