Post Reply 
->HMS doesn't work properly
04-07-2023, 05:19 PM
Post: #1
->HMS doesn't work properly
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.
Find all posts by this user
Quote this message in a reply
04-07-2023, 10:56 PM
Post: #2
RE: ->HMS doesn't work properly
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.

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

User(s) browsing this thread: