JE,

The original data comes from a Flight Data Recorder parameter. We have to
multiply the data by 180 to convert to a decimal degree format. Now what I
need is to know how to convert from decimal degree (dd) to degrees, minutes,
and seconds (dd mm' ss").

Thanks,

Tim

"JE McGimpsey" wrote:

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.