close
Newbie.
Is there a simply way to convert a decimal angle in dec/min/sec in Excel 2000?
Thank you in advance for your assistance.
One way:
If you just want to display the results:
=TEXT(A1/24,quot;hh° mm' ss\quot;quot;quot;)
If you want to calculate with the results:
=A1/24
format with Format/Cells/Number/Custom hh° mm' ss\quot;In article gt;,
Arch gt; wrote:
gt; Newbie.
gt; Is there a simply way to convert a decimal angle in dec/min/sec in Excel 2000?
gt;
gt; Thank you in advance for your assistance.
全站熱搜