Or copy paste this formula I created. =CONCATENATE(ROUNDDOWN(A1,0),"°",ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0),"'",ROUND(((A1-ROUNDDOWN(A1,0))*60-ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0))*60,2),"""")
In Excel 365, everything is easier, simpler and shorter If the value in B1 is: 72.29861 then this formula: =LET(x,INT(B1),y,(B1-x)*60,CONCAT(x,"°",INT(y),"'",ROUND(((y-INT(y))*60),0))) will yield this result: 72°17'55
Very motivational music 🎶 with video wow very nice you achieve billion likes 💓
Thank you so much 😀
Or copy paste this formula I created.
=CONCATENATE(ROUNDDOWN(A1,0),"°",ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0),"'",ROUND(((A1-ROUNDDOWN(A1,0))*60-ROUNDDOWN((A1-ROUNDDOWN(A1,0))*60,0))*60,2),"""")
THANKS
Holly cow man thanks
What's format cell has been used?
How to get East, West North,
and south info by this formula? thx in advance.
❤
❤️❤️
In Excel 365, everything is easier, simpler and shorter
If the value in B1 is: 72.29861
then this formula:
=LET(x,INT(B1),y,(B1-x)*60,CONCAT(x,"°",INT(y),"'",ROUND(((y-INT(y))*60),0)))
will yield this result:
72°17'55