how make an angle to show in degree, minute,second instead of degree

[EXCEL$B!!(BNEWS]

hi,

i wonder how to change an angle to show in degree, minute,second instead of
degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks

 

[Dave Peterson]

I'd start with Chip Pearson's site:
http://cpearson.com/excel/latlong.htm

 

[Rick Rothstein \(MVP - VB\)]

Here is one way...

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & Format((DecimalDegrees - _
Int(DecimalDegrees)) / 24, "\.nnss")

Rick

 

[EXCEL NEWS]

Thanks a lot

Here is one way...

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & Format((DecimalDegrees - _
Int(DecimalDegrees)) / 24, "\.nnss")

Rick

 

[Rick Rothstein \(MVP - VB\)]

You are welcome. As it turns out, we can simplify the expression somewhat..

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & _
Format(DecimalDegrees / 24, "\.nnss")

Rick