I don't understand your calculations

How are you going from decimal degrees of 31.3463508840 to N34* 50'
56.04"?? Where are the extra degrees coming from?

Seems to me that 31.3+ decimal degrees should yield a DMS of

31°20'46.86"




In article ,
"Tim Ashcom" wrote:

I did, but not much help for a novice Excel user. What will help the best is
an exact formula to do the calculations.

Thanks for any additional assistance.