+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: General Forum (/forum-4.html)
+--- Thread: HP 50g HMS problem (/thread-19788.html)
HP 50g HMS problem - AveDonat - 04-07-2023 05:34 PM
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.
RE: HP 50g HMS problem - Gil - 04-07-2023 10:31 PM
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