Post Reply 
HP 50g HMS problem
04-07-2023, 05:34 PM
Post: #1
HP 50g HMS problem
Hello everyone,

lets say I have an angle gama = 1.96834347921E-7. I used ->HMS to convert it from decimal form to HMS form. The result was: 7.08603652516E-8 . That is the wrong result because in excel when I converted the same angle using DEGREES(), the result was 1.1278E-5 .

Can you please help me to solve this problem?

Thank you.
Find all posts by this user
Quote this message in a reply
04-07-2023, 10:31 PM (This post was last modified: 04-07-2023 11:05 PM by Gil.)
Post: #2
RE: HP 50g HMS problem
The given result by HP seems to me perfectly correct
(and Excel too).

1 degree (1 hour) —> 3600 s
Then, if you have in (decimal) degrees (d.dddddd) 1.96834347921E-7
you have to multiply it by 3600 to get the number of s:
1.96834347921E-7 × 3600 = 7.08603652516E-4 s

And your initial value 1.96834347921E-7 (in degrees d.dddddd) with
—>DMS gives precisely 7.08603652516E-8
= 0. 00 0000708603652516,
to be read as 0h 00' 0.000708603652516s.

However, if your initial angle 1.96834347921E-7 is in radian,
then the corresponding value in (decimal) degrees is:
1.96834347921E-7 × 360/(2×pi) = 1.12777773991E-5 (in d. ddddd).

Excel given function converts, here, radian (your initial value) to degrees (d.ddddds),
whereas HP command —>DMS converts your initial value from d.ddddddd into d.mmsssss.

Two different things, all of them correct, depending on your initial input
1.96834347921E-7 [ radian]
or 1.96834347921E-7 [decimal degrees d.ddddddd]

Regards
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 2 Guest(s)