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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()