+- 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: ->HMS doesn't work properly (/thread-19786.html)
->HMS doesn't work properly - AveDonat - 04-07-2023 05:19 PM
Hi everyone,
I have a problem with the ->HMS function. My angle is: 1.96834347921E-7 . In excel, when I used the function DEGREES(), the result was 1.1278E-5 . But when I used the ->HMS function on my HP 50g calculator to convert the angle from decimal form to HMS form, the result was 7.08603652516E-8.
Can you guys tell me what is the problem?
Thank you.
RE: ->HMS doesn't work properly - Gil - 04-07-2023 10:56 PM
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 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.
Regards